Re: Returning a REF cursor

|
| This helps. I guess I was hoping not to pass all 20+ parameters that this procedure accepts.
|
| As a function, I am able to call the function passing only the parameters I need, using the named parameter method.
|
| But in this syntax, if I omit the first parameter, I get an error.
|
| There must be a way, say from SQLPlus, to call a procedure, and only supply the parameters you need for that call.....not all of
the parameters in a positional line.......
|
| Thanks.

>>> But in this syntax, if I omit the first parameter, I get an error.

Why don't you copy and paste what you do and get as I did instead of trying to explain it (and failing as I don't understand what you actually did)?

Regards
Michel Received on Mon Aug 01 2016 - 19:23:45 CEST