This is a discussion on how to copy value of an in out parameter from calling procedure within the Oracle Miscellaneous forums, part of the Oracle Database category; --> I am calling a procedure(order) from a calling procedure (caller). Order uses an In out parament (Ser_no) Order is ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am calling a procedure(order) from a calling procedure (caller). Order uses an In out parament (Ser_no) Order is supposed to return a serial number. how can i copy the value returned by Order to a local variable of Caller. thanks. |
| |||
| talk2paras@gmail.com wrote: > I am calling a procedure(order) from a calling procedure (caller). > Order uses an In out parament (Ser_no) > > Order is supposed to return a serial number. > > how can i copy the value returned by Order to a local variable of > Caller. > > thanks. Demos of the use of OUT parameters can be found in Morgan's Library at www.psoug.org under Procedures. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) |
| ||||
| <talk2paras@gmail.com> wrote in message news:1143747371.075951.223880@i39g2000cwa.googlegr oups.com... :I am calling a procedure(order) from a calling procedure (caller). : Order uses an In out parament (Ser_no) : : Order is supposed to return a serial number. : : how can i copy the value returned by Order to a local variable of : Caller. : : thanks. : this sounds like just typical assignment, ie, localvar := localvar_sent_as_in_out_variable or, just pass the local var as the in/out variable -- that's what in/outs are there for. ++ mcs |