MySQL Forums
Forum List  »  Stored Procedures

Passing Values
Posted by: Lamaru Omar
Date: October 27, 2005 02:17AM

Hello

I have one simple and short question, but first my example:

DELIMITER //;
CREATE PROCEDURE test (table_name VARCHAR(50), val1 INT, val2 VARCHAR(255))
BEGIN
INSERT INTO table_name VALUES (val1,val2);
END; //

I would like to get a name of the table from value given in procedure arguments.
So the question is, can I somehow use 'table_name' like in example above ?
If yes, how can I do this ?

Thanks
Omar

Options: ReplyQuote


Subject
Views
Written By
Posted
Passing Values
2626
October 27, 2005 02:17AM
1810
October 27, 2005 05:29AM


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.