OCI8 Stored Procedure return values

[wxdqz]

System Info: RedHat 7.1 Oracle 8.1.7 PHP 4.0.6 Apache 1.3.22


I have an oracle function that I call as follow in sqlplus to execute my package
as a test:

--------------------------------------------------------------------------------

DECLARE
vNum NUMBER;

BEGIN
DBMS_OUTPUT.PUT_LINE('Testing Package ---');
vNum := THE_PKG.modifyUser(0,'user','pass','first','last','[email protected]');
DBMS_OUTPUT.PUT_LINE(vNum);
END;

--------------------------------------------------------------------------------


In my PHP file I can get the procedure to successfully run using the following
syntax, but cannot capture the return value because it is stuck in the statement.
I really need that return value! Please please help... Thanks so much for your
time.


--------------------------------------------------------------------------------

...$conn = connection

$PKGStatement = "declare NUM; begin NUM := theisenonline_pkg.modifyUser($REQ_Id, '$REQ_Uname', '$REQ_PWord', '$REQ_FName', '$REQ_LName', '$REQ_EMail'); end;";
$sth = OCIParse($conn, $PKGStatement);
OCIExecute($sth);


--------------------------------------------------------------------------------


Steven Theisen (<!-- e --><a href="mailto[email protected]">[email protected]</a><!-- e -->)