Re: Dynamic SQL. Is it possible?
Thomas, I found an example in the official documentation section 13.7 SQL Syntax for Prepared Statements. I tried the interactive example using MySql command line and it does seem to work ok. Whether that translates into an SP to do what I want is another question. That can be my weekend project at home! If it does work reliably, I will post my SP just in case it has interest appeal to a wider audience!
Thanks.
Subject
Views
Written By
Posted
3625
November 04, 2005 01:40AM
2760
November 04, 2005 03:51AM
Re: Dynamic SQL. Is it possible?
2489
November 04, 2005 06:46AM
2797
November 04, 2005 08:51AM
2488
November 23, 2005 10:50AM
2442
November 23, 2005 02:18PM
2514
November 04, 2005 08:54AM
2540
November 04, 2005 10:06AM
6940
November 04, 2005 03:40PM
2560
November 04, 2005 05:21PM
2625
November 04, 2005 04:45PM
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.