Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Parameter substitution

Re: Parameter substitution

From: John P. Higgins <jh33378_at_deere.com>
Date: Tue, 04 Aug 1998 20:10:54 -0500
Message-ID: <35C7B11D.1EB4F60D@deere.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US