Re: Compiling pl/sql in sqlplus with an @ char within the code?

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 08 Jun 2006 14:49:56 +0200
Message-ID: <44881e50$0$4496$9b4e6d93@newsread2.arcor-online.net>

Jeremy schrieb:
> In article <448814db$0$11078$9b4e6d93_at_newsread4.arcor-online.net>, Maxim
> Demenko says...

>> It seems, sqlplus gets broken on the first nonwhitespace "@" character ( 
>> regardless it is quoted).
>>

>
> I had also been wondering if there was a "set" statement I could use in
> sqlplus to alter the defaults (e.g. the define is usually the & char)
>
> e.g.
>
> SQL> set define {
> SQL> set runscript }
>
> (I made the second one up for illustrative purposes)
>

I don't quite understood your question,
clearly you can reassign the default '&' for substitution variables to another character or disable substitution behaviour at all (and after your script is run reenable it)
See
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#sthref2736

Best regards

Maxim Received on Thu Jun 08 2006 - 07:49:56 CDT