MySQL Forums
Forum List  »  Stored Procedures

Re: how to call table name in a proc as a parameter
Posted by: Peter Brawley
Date: July 13, 2012 03:03AM

'dev_schema'.'master_table' is not a valid string param. If you want to pass in dbname.tblname as a single param, you need to do it as 'dev_schema.master_table', or as two params 'dev_schema' and 'master_table', and deal with your choice in the sproc code.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to call table name in a proc as a parameter
1215
July 13, 2012 03:03AM


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.