Returning values from oracle stored proc

[adaml]

hello - i created a stored proc with one in and one out variable:

SELECT Customer_ID
INTO Cust_ID_Out
FROM Isu_Customer
WHERE Email = Customer_Email AND ROWNUM=1;

The purpose is to return value 'Cust_ID_Out' to the php which calls this sp. the php code is as follows:

    $s_sp = "begin ISU_CUSTOMER_GETBY_EMAIL('$sEmail',:Cust_ID_Out); end;";

    $a_Sql_Parse = ociparse($cn_cur,$s_sp);
    OCIBindByName($a_Sql_Parse, ":Cust_ID_Out", &$lCust_ID);

    ociExecute($a_Sql_Parse);

Executing this code returns a warning of 😮CIStmtExecute: OCI_NO_DATA.
This is regardless of if the record exists or not. Generally speaking, should i be able to grab values from the stored proc. in php using the "SELECT ... INTO" convention? Is this the corect way to do this? thanks - Adam

[pencils]

Hey Adam try this, it worked for me:

PROCEDURE ISU_TEST_4 (Customer_Email IN varchar2, Cust_ID_Out OUT number, ERROR OUT number) IS
BEGIN

SELECT Customer_ID
INTO Cust_ID_Out
FROM Isu_Customer
WHERE Email = Customer_Email AND ROWNUM=1;
ERROR := 0;
EXCEPTION
when others then
ERROR := 1;

END;

$cn_cur = ocilogon($a, $b, $c);

$sEmail = "[e-mail]";

$s_sp = "begin ISU_TEST_4 ('$sEmail',:Cust_ID_Out, :ERROR); end;";

$a_Sql_Parse = ociparse($cn_cur,$s_sp);
OCIBindByName($a_Sql_Parse, ":Cust_ID_Out", &$lCust_ID);
OCIBindByName($a_Sql_Parse, ":ERROR", &$lError);

ociExecute($a_Sql_Parse);

print $lCust_ID;
print $lError;

ocifreestatement($a_Sql_Parse);
ocilogoff($cn_cur);