OCI8 Stored Procedure return values

[Anon]

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','[e-mail]');
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-mail])

[Anon]

http://www.php.net/manual/en/function.ocibindbyname.php

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[Anon]

I know I am a little slow, but how does this help me? Can I get the declare statement out of there now? I guess I need an example. Sorry 🙁

[Anon]

<?php
$pno = 10;
$pname = "junkdata901" / Pre-create output variable /

$conn = OCILogon("yourusername", "yourpassword", "yourdatabaseservice");

/ For procedure with "OUT" param: /
$stmt = OCIParse($conn, "begin your_procedure(:pno, :name); end;");
OCIBindByName($stmt, ":pno", &$pno, -1);
OCIBindByName($stmt, ":name", &$name, 11);

/ ...or... /

/ For function: /
$stmt = OCIParse($conn, "begin :name := your_function(:pno); end;");
OCIBindByName($stmt, ":pno", &$pno, -1);
OCIBindByName($stmt, ":name", &$name, 11);

$result = OCIExecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
echo $name;
?>

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[Anon]

Thanks so very much I have it working now. Thanks for all your help!!