Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Parameters between scripts
If the script is in SQL/Plus, you may define the variable once,
and use it more than once:
ACCEPT myvariable PROMPT 'Enter the value: ' exec C001(parm, parm, parm, &myvariable. ); exec C002(parm, parm, parm, &myvariable. );
or
@C001
@C002
(The parameter is already defined and is alive in SQL/Plus)
Robert Proffitt
Beckman Coulter
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 17:01:58 CDT