| OWA: Passing dynamic parameters to pl/sql [message #77374] |
Thu, 20 June 2002 08:00  |
Huch
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi,
To use OWA, the standard way is:
In the HTML form, whatever name/value pairs exist, the name from each name/value pair must exist in the PL/SQL procedure declaration. So if my HTML form has inputs name,age, address then my PL/SQL procedure being called in the ACTION clause must have name, age, address in the declaration.
I have a situation where the NAME field itself is dynamic. In addition, the no of name/value pairs also changes depending on certain conditions when the form is generated.
So how do I handle this in PL/SQL ?
Thank
|
|
|
|
| Re: OWA: Passing dynamic parameters to pl/sql [message #77382 is a reply to message #77374] |
Wed, 17 July 2002 01:50  |
pallavi
Messages: 14
Registered: April 2001
|
Junior Member |
|
|
One of the solutions could be:
Have a set of hidden fields with same name say "names".
And all the elements on the form will have same name say "form_element". So when the form is submitted these two will get submitted as array.
The pl/sql procedure to which this will be submitted will have two input params. as:
names in owa_util.ident_arr,
form_elements in owa_util.ident_arr.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
