Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » HTP package (oracle 9i)
HTP package [message #457581] Tue, 25 May 2010 04:57 Go to next message
ganesh_n
Messages: 4
Registered: May 2010
Junior Member
Hi,

I need to create a input text box followed by a "update" button using HTP package in PL/SQL(Oracle 9i)

The screen(its an interface) looks as below

Order Number "Input Text Box" "Update Button"

The scenario is as below..

When an order number (integer) is entered in the text box and the "Update" button is clicked then that Order number shold get updated in the database.

Thanks in advance. PLs reply ASAP.
Re: HTP package [message #457583 is a reply to message #457581] Tue, 25 May 2010 05:02 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
What is your code?
Have you started writing one?

By
Vamsi
Re: HTP package [message #457585 is a reply to message #457583] Tue, 25 May 2010 05:07 Go to previous messageGo to next message
ganesh_n
Messages: 4
Registered: May 2010
Junior Member
Hi vamsi,

I got no good knowledge using HTP packages with PL/SQL.
I have written few lines for creation of text Box. its as below.

g_error_step:= 'Making textfields for css order number';
HTP.tableOpen( cattributes => ' border="0" cellpadding="0" cellspacing="1" width="75%"' );
HTP.tablerowopen;
HTP.tabledata(HTF.bold('<font color=blue>CSS Order Number : </font>')||htf.formText(cname=>'p_css_order_num',cvalue=>rtrim(cpo_curr_val.css_order_num),csize=>'6',cmaxlength=>'6')||v_db_id);
HTP.tablerowclose;
HTP.tableclose;
htp.hr;

i want to create a button nxt to the text box, the click of that should re direct it to a procdeure or fuction where update statement is ther ..
Re: HTP package [message #457602 is a reply to message #457585] Tue, 25 May 2010 06:17 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Check this.

By
Vamsi
htp package [message #457908 is a reply to message #457581] Wed, 26 May 2010 06:13 Go to previous messageGo to next message
ganesh_n
Messages: 4
Registered: May 2010
Junior Member
Hi,

I need to create a button using HTP package in oracle (pl/sql).
and when the button is clicked it should redirect to a procedure with 2 parameters.

Can anyone help me out as to how to write that code.ASAP.

Thanks in advance.
Re: htp package [message #457997 is a reply to message #457908] Wed, 26 May 2010 11:04 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
See demo pakage ==> http://www.orafaq.com/forum/mv/msg/81574/237803/45693/#msg_237803

Also see ==> http://www.orafaq.com/forum/mv/msg/158064/457757/45693/#msg_457757
Re: htp package [message #458056 is a reply to message #457997] Thu, 27 May 2010 02:33 Go to previous message
ganesh_n
Messages: 4
Registered: May 2010
Junior Member
Thanks andrew... will check ...
Previous Topic: ORACLE HTP TABLE, highlight table Row on mouseOver
Next Topic: set buttonwidth
Goto Forum:
  


Current Time: Wed Jun 03 02:20:22 CDT 2020