Passing Values
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
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.