OraFAQ Forum: Client Tools » set escape ON in Stored Proc

Home » Other » Client Tools » set escape ON in Stored Proc

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

set escape ON in Stored Proc [message #38631]

Wed, 01 May 2002 13:16

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

Report message to a moderator

Re: set escape ON in Stored Proc [message #38632 is a reply to message #38631]

Wed, 01 May 2002 14:25

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:

Code: [Select all] [Show/ hide]

update my_table
   set name = 'Short & Interm'
 where ...;

Report message to a moderator

Re: set escape ON in Stored Proc [message #38638 is a reply to message #38631]

Thu, 02 May 2002 09:27

Tracy
Messages: 43
Registered: January 2000

Member

thanks!

Report message to a moderator

Previous Topic:	I am perplexed on how to do this...pls help...
Next Topic:	ORA-00918 : column ambiguously defined. Please help!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 18:43:02 CDT 2025