Home » Other » Client Tools » set escape ON in Stored Proc
set escape ON in Stored Proc [message #38631] Wed, 01 May 2002 13:16 Go to next message
Tracy
Messages: 43
Registered: January 2000
Member
Hi,

I need to find a way in my stored procedure to SET ESCAPE ON because the procedure will update a table in which the literal contains "&"

for example:

CREATE OR REPLACE PROCEDURE Temp
AS

set escape on ---->>causes error
BEGIN

UPDATE MY_TABLE
SET NAME = 'Short & Interm'
WHERE NAME = 'Short and Interm';

What works in SQL*Plus does not work in PL/SQL

Many thanks,
Tracy
Re: set escape ON in Stored Proc [message #38632 is a reply to message #38631] Wed, 01 May 2002 14:25 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Tracy, you don't need the 'set escape on' command - and it is not valid syntax anyway - in PL/SQL. In your procedure, you can just:

update my_table
   set name = 'Short & Interm'
 where ...;
Re: set escape ON in Stored Proc [message #38638 is a reply to message #38631] Thu, 02 May 2002 09:27 Go to previous message
Tracy
Messages: 43
Registered: January 2000
Member
thanks!
Previous Topic: I am perplexed on how to do this...pls help...
Next Topic: ORA-00918 : column ambiguously defined. Please help!
Goto Forum:
  


Current Time: Thu Mar 28 18:02:17 CDT 2024