[EMAIL PROTECTED] wrote:
Hi DBAs,
I have strings that are being passed into parameters that contain embedded
single quotes. Obviously this fails the insert and
update statements. How can I handle these inside stored procedure?
Thanks
Rick
replace(my_parameter, , '')
--
double up the quotes:
'string string string '' string string strin'
will give you a string with one single quote within.
p.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 01 July 2002 16:35
To: Multiple recipients of list ORACLE-L
Subject: How to
Rick,
Actually, it should work fine unless you are using dynamix sql, in which
case, you can use the REPLACE function to add an additional single quote.
Within the procedure you are calling, you may do the following:
loc_quote varchar2(1) := ;