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
2397
July 13, 2012 06:55AM
1321
July 13, 2012 10:01AM
1541
July 13, 2012 04:26PM
1215
July 13, 2012 10:04PM
1326
July 18, 2012 05:03AM
Re: Dynamic SQL problem in Store Procedure
1273
July 18, 2012 09:54AM
1046
September 30, 2012 02:14PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.