any Acer for Stored Procs ? How to escape quotes in SP parameter. PL HELP
Hi Folks I created a Stored procedure that can take a string as a parameter.It all looks good EXCEPT for the part where the string contains commas and single quotes that must be escaped.
<> How can you escape the ',' and ' ' ' ( single quote ) character. Tried the \ does not work. Tried Escape \ does not work. Tried ".......string" c does not work. <> How can you pass as parameter, a string that has something like ' blah blah , account=('$d$metc') ;'
to a stored procedure. Any help is appreciated. Thanks Samuel Carpenter
Re: any Acer for Stored Procs ? How to escape quotes in SP parameter. PL HELP
Hi rgs what if the sp has parameters like
call xyz ('p1','p2' ) only and p2 is a long string='blah=1 , blah2=2 , paramater1=('Merry Xmas'), parameter2="Somelse ' I'd like to pass the string as the parameter after conveying to the SP that just take this entire thing as a string and don't bother to parse it any more. How could I do that