Problem solved!
Thanks to everyone who helped out (and to our system DBA for reminding me
that an Oracle function is just a type of stored procedure).
For what it's worth, here is the code that I wound up using (sensitive
company information xxxx'ed out, of course):
<?php
// Establish Oracle connection
putenv("ORACLE_SID=xxxx");
putenv("ORACLE_HOME=xxxx");
$db = ocilogon("xxxx","xxxx","xxxx");
if(!$db) die("Database connection failed.");
// Execute stored procedure
$functionCall = "begin :result := hubins_func('Richard','Y');end;";
$parsedFunctionCall=ociparse($db,$functionCall);
ocibindbyname($parsedFunctionCall,":result",$result,10);
if(!ociexecute($parsedFunctionCall)) die ("Stored Procedure execution
failed.");
print("Value of primary key: $result");
// End Oracle connection
ocilogoff($db);
?>
The value of $result is the primary key which is associated with the value
inserted into the database with the hubins_func stored proc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
