Re: Dynamic SQL problem in Store Procedure
> MySQL tells me there is any error in my syntax. And, I can't see it.
It has multiple errors, eg ...
('SELECT ID, replace(replace(field_a,''*'',''''),''\''',''\\'''')
confounds data values and column references in a way that cannot work.
Consider writing out a detailed specification of what this sproc is meant to do.
Subject
Views
Written By
Posted
2245
July 13, 2012 06:55AM
1239
July 13, 2012 10:01AM
1452
July 13, 2012 04:26PM
1126
July 13, 2012 10:04PM
1231
July 18, 2012 05:03AM
Re: Dynamic SQL problem in Store Procedure
1180
July 18, 2012 09:54AM
960
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.