Re: Dynamic Source
Hi!
I don't think so. You see, the source command is a command directed towards the mysql command line client (like delimiter, tee, notee etc). It is not part of the actual SQL/PSM syntax. In other words, these commands are preprocessed by the cient and *never sent to the server*.
It makes sense too: what is the server to do with this command? (The client that runs this procedure could be running in a context that does not even know of a filesystem).
What you can do - but the support is limited - is, use the PREPARE/EXECUTE/DEALLOCATE syntax:
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
and
http://mysql.gilfster.com/page.php?parent_id=1.3&page_id=1.3.6
Subject
Views
Written By
Posted
2359
January 11, 2006 12:19PM
Re: Dynamic Source
1356
January 11, 2006 12:58PM
1294
January 12, 2006 07:24AM
1310
January 12, 2006 08:46AM
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.