oracle: return values of functions
| From: | Florian Clever | Date: | Wed, 11 Oct 2000 06:14:31 +0000 |
| Subject: | oracle: return values of functions | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3510@lists.php.net to get a copy of this message | ||
Hi,
I think the best way to do this is to bind the result (You are talking
about PL/SQL functions right?):
$sql = "begin :retval = PL_SQL_FUNCTION_Call(:param1, :param2, ... );
end;"
$stmt = OciParse($con, $sql);
OCIBindByName($stmt,":retval",&$retval, -1);
OCIBindByName($stmt,":param2",&$param1, -1);
OCIBindByName($stmt,":param2",&$param1, -1);
OciExecute($stmt);
OciFreeStatement($stmt);
Good Luck,
Florian
> hi!
>
> is there a possibility to get the return value of an oracle function
> to a php variable?
>
> regards,
> mac
--
Florian Clever
fc@clever-soft.com
http://www.Clever-Software-Solutions.de/
PGP Key @ ldap://certserver.pgp.net/
"C combines all the power of assembly language with all the ease of use
of assembly language" -- trad