Re: Funzioni passaggio di parametri
Grande!!!!!!!!! funziona
Inserisco un esempio cosi se qualcun altro ha lo stesso problema
DELIMITER $$
DROP PROCEDURE PROVA$$
CREATE PROCEDURE PROVA(IN tabella varchar(100))
begin
SET @sql := CONCAT('SELECT Id FROM ', tabella);
PREPARE mySt FROM @sql;
EXECUTE mySt;
DEALLOCATE PREPARE mySt;
end$$
DELIMITER ;
la funzione si chiama cosi
CALL PROVA('nometabella')
grazie ancora per l'aiuto
Edited 1 time(s). Last edit at 05/04/2010 03:56AM by Fabrizio Marazita.
Subject
Views
Written By
Posted
6032
April 17, 2010 04:54AM
2565
April 21, 2010 06:23PM
2108
May 04, 2010 03:19AM
Re: Funzioni passaggio di parametri
2187
May 04, 2010 03:49AM
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.