| 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
|
|
|
|
| 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:
update my_table
set name = 'Short & Interm'
where ...; |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
