Execute Statement For a Stored Procedure with In and Out Parameters
Hi all,
I have a stored procedure, which is calling a select statement. Here it is...
CREATE OR REPLACE PROCEDURE BLABLA_VIEW_PROCEDURE
*(BLABLA_KEY IN NUMBER,*
XML_OUTPUT OUT VARCHAR)
AS
BEGIN
SELECT SYS.XMLTYPE.getStringVal(OBJECT_VALUE) into XML_OUTPUT FROM BLABLA_VIEW WHERE extractValue(OBJECT_VALUE, '/BLABLA_TYPE/BLABLA_KEY') = 2876;
END;
It is having both IN and OUT parameters as shown above. I am able to compile and excute the procedure.
The problem I would like to share with all is...
I want to execute the entire Store Procedure using a single EXEC command.
I have tried different ways in using the EXEC command but, of no use.
Could some one help me out??
Thanks in advance.
Edited by: user10763276 on Jun 3, 2010 3:47 PM