Re: select current value of procedure arguments?

"prl" <prlawrence_at_lehigh.edu> wrote in message news:c0rkk0$1544$1_at_fidoii.CC.Lehigh.EDU...
| I know I can find the names of all my procedure's arguments (and other
| info about them) in sys.argument$. But, there is no field named
| "CURRENT_VALUE" in that table. :-(
|
| Basically, I have to use plain old varchar2 arguments because a WWW Form
| is passing in the values. I'd like to LOOP through the args and call a
| function each time with the arg name and it's current value.
|
| Any ideas?
| prl

sounds like you're using PL/SQL web toolkit and you need to use 'flexible parameter passing'

the concept is that you declare your procedure with two PL/SQL table input parameters, and all applicable HTML FORM INPUT fields are passed via these PL/SQL tables as name/value pairs

example:

    procedure proc( name_array in vc1000, value_array in vc1000 )     is
    begin

• gather the passed parameters for i in 1 .. name_array.count loop ....

this requires the declaration of the pl/sql table datatype, and requires the following URL call syntax (the difference is the '!' in front of the procedure name)

    http://www.host.com/pls/dad/!proc?x=john&y=10&z=doe

• mcs