Re: Dynamic SQL problem in Store Procedure
set @s=
concat('SELECT ID, replace(replace(field_a,\'*\',\'\'),\'\\\'\',\'\\\\\'),
' FROM table where field_b = ',vVariable);
but i guess it will show error as resulting query will contain \ which is not allowed column name
if get your idea right
Edited 1 time(s). Last edit at 09/30/2012 02:21PM by Yurii Korotia.
Subject
Views
Written By
Posted
2239
July 13, 2012 06:55AM
1227
July 13, 2012 10:01AM
1447
July 13, 2012 04:26PM
1123
July 13, 2012 10:04PM
1226
July 18, 2012 05:03AM
1177
July 18, 2012 09:54AM
Re: Dynamic SQL problem in Store Procedure
954
September 30, 2012 02:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.