Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Parameter substitution
Try this:
@Inner &var1 &var2
Ariel Kirson wrote:
> Hello all,
>
> I am trying to call a SQL script (here-after "Inner")
> from within another SQL script (here-after "Outer").
> My problem is with using parameters.
>
> the "Inner" script expects to receive &1 and &2
> and the "Outer" script passes two parameters as
> follows :
>
> @Inner var1 var2
>
> When "Inner" executes, it receives the values 'Var1'
> and 'Var2' rather than their values.
>
> My question is how to cause the values of Var1 and Var2
> to be used by "Inner", rather than their names.
>
> Thanks in advance,
>
> Ariel Kirson
> Ex Libris.
Received on Tue Aug 04 1998 - 20:10:54 CDT
![]() |
![]() |