...

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



holty
11-21-2003, 11:21 AM
Hi,

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....

holty
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....

holty
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



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

OCIExecute($stmt);

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

{

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

<?php }
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
</table>

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?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum