stored procedure not working
I'm trying to Pass Parameters with Procedures
the first query i run is
create procedure helloprocedure(OUT param1 VARCHAR(100))
begin
set param1 = 'Hello World';
end
then i run
call helloprocedure(@a);
and when i run
select @a;
i get
NULL instead of Hello World
is there any reason for that?
Subject
Written By
Posted
stored procedure not working
July 29, 2005 05:39AM
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.