Re: Simple stored procedure question

[Les Stockton]

I ended up calling the procedure, but now it says there's a syntax error at or near [?]

I tried it with DEFAULT. I tried without DEFAULT.
So what's wrong with:
PREPARE stmt1 FROM 'INSERT INTO [?] ';

Currently, this is the stored procedure:

CREATE PROCEDURE `MyAddRecord`(IN TblName varchar(50),OUT NewIDVal int)
BEGIN
PREPARE stmt1 FROM 'INSERT INTO [?] ';
SET @a = TblName;
EXECUTE stmt1 USING @a;
SET NewIDVal = LAST_INSERT_ID();
END

So what do I need to do with the PREPARE statement or the INSERT within it?




Edited 1 time(s). Last edit at 01/12/2006 04:52PM by Les Stockton.