simple procedure does not return anything
Hello everyone,
I created a simple procedure
DELIMITER //
CREATE PROCEDURE test (IN var1 double,IN var2 double, IN var3 int)
BEGIN
SELECT * FROM sometable;
END //
DELIMITER ;
...
CALL test();
although the query itself returns data, the procedure does not
please help me out
thanx
Subject
Views
Written By
Posted
simple procedure does not return anything
2130
September 14, 2015 08:19AM
867
September 14, 2015 12:44PM
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.