Using a PL/SQL table column as an IN OUT Parameter?

[Petemush]

Hello,

I have a procedure with a number of formal parameters where the actual parameters I pass in are PL/SQL table columns.

I wanted to know, if I make some of the formal parameters IN OUT parameters, will the PL/SQL table columns get updated when the formal parameters are changed within the procedure? Or will I have to forget it and update the PL/SQL table column directly from within the procedure?

Just not sure if it'll work or not!

Cheers!

Pete

 

[SantaMufasa]

Pete,

If you post an excerpt of your working code that depicts both the parameter definitions and the procedure invocation, I'm certain we can resolve your question with a proof-of-concept code set.

Mufasa
(aka Dave of Sandy, Utah, USA @ 00:58 (13May04) UTC (aka "GMT" and "Zulu"), 17:58 (12May04) Mountain Time)