: Thu, January 10, 2002 2:02 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: reading variables
>
> > -Original Message-
> > From: Lance Prais [ <mailto:[EMAIL PROTECTED]>]
> >
> > I am using toad.
> >
> > >If I
Title: RE: reading variables
> -Original Message-
> From: Lance Prais [mailto:[EMAIL PROTECTED]]
>
> I am using toad.
>
> >If I use the following for to reference a variable in my code:
> >Update Primus_Temp_Dump set owner =(&test) where secure_id = Se
I am using toad.
-Original Message-
Sent: Wednesday, January 09, 2002 3:02 PM
To: Multiple recipients of list ORACLE-L
& variables work fine in sqlplus but not anywhere else, In what tool
are you programming?
[EMAIL PROTECTED] wrote:
>If I use the following for to reference a varia
Do a SHOW DEF at the SQL prompt. What does it show? If anything other than
&, do a
SQL> Set def &
Raj
"Lance Prais" <[EMAIL PROTECTED]>@fatcity.com on 01/09/2002 05:35:21
PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EM
& variables work fine in sqlplus but not anywhere else, In what tool
are you programming?
[EMAIL PROTECTED] wrote:
>If I use the following for to reference a variable in my code:
>Update Primus_Temp_Dump set owner =(&test) where secure_id = Secure;
>
>I get this compile error:
>PLS-00103: Enco