Re: Error on variable when running a procedure
Posted by:
Rick James
Date: November 21, 2013 05:19PM
`foo` is a literal -- so substitution done.
You will need to construct the SELECT statement using CONCAT to fill in the column name and table name. Then use PREPARE and EXECUTE to 'run' the SELECT.
Subject
Views
Written By
Posted
2413
November 19, 2013 10:31AM
Re: Error on variable when running a procedure
929
November 21, 2013 05:19PM
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.