RE: reading variables

2002-01-10 Thread אדר יחיאל
: 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

RE: reading variables

2002-01-09 Thread Jacques Kilchoer
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

RE: reading variables

2002-01-09 Thread Lance Prais
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

Re: reading variables

2002-01-09 Thread Rajesh . Rao
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

Re: reading variables

2002-01-09 Thread orantdba
& 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