Error 1064 Linea 1
CREATE DEFINER=`root`@`localhost` PROCEDURE `PR_Prueba`(INOUT `Salida` BIGINT, IN `Cond1` CHAR(10))
LANGUAGE SQL
NOT DETERMINISTIC
MODIFIES SQL DATA
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE CSql varchar(100);
SET CSql = CONCAT('SELECT Count(*) INTO @Salida FROM ',Cond1,';');
PREPARE Linea FROM @CSql;
EXECUTE Linea;
SELECT @Salida INTO Salida;
DEALLOCATE PREPARE Linea;
END
Subject
Views
Written By
Posted
Error 1064 Linea 1
610
October 01, 2024 08:01AM
Sorry, only registered users may post in this forum.
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.