View Full Version : Running a Function from within a Package - Oracle

11-21-2003, 11:21 AM

I would like to pull out Information from a table in oracle. Within this data will be several ID's.

I would like to then pass these ID's one by one into functions within a package to pull out more data.

Has anyone done this before or can provide help or code?

I'm unsure how to call the function after selecting the data....

11-21-2003, 11:55 AM
The initial select will be a stored procedure - I can't find how to call that in PHP....

Then pull the ID out of the stored procedure to call the functions in the package....

11-21-2003, 04:00 PM
I have wrote my oracle stored procedure and it works fine...

I just need to be able to call it and return its results in php and then call a function in a package....

here is my code - I'm having a few probs

$conn = OCILogon("user","pass","db");
$stmt = OCIParse($conn,"begin sp_customerdata(2,'UK'); end;");


while (OCIFetchInto($stmt, &$arrCustomer, OCI_ASSOC+OCI_RETURN_NULLS))


<?= $arrCustomer['Customer_ID'] ?>
<?= $arrCustomer['Start_Date'] ?>
<?= $arrCustomer['End_Date'] ?>

<?php }

I get this error:

Warning: ocifetchinto(): OCIFetchInto: ORA-24374: define not done before fetch or execute and fetch

on this line:

while (OCIFetchInto($stmt, &$arrCustomer, OCI_ASSOC+OCI_RETURN_NULLS))

Any ideas?