Calling ORACLE stored function from php
Posted: Mon Jul 10, 2006 7:15 am
I have this function declaration
FUNCTION GENSECURE RETURN VARCHAR2;
I am trying to call it in PHP with the following code
$sql="begin :bind = GENSECURE; end";
$s = ociparse($c, $sql);
OCIBindByName($s, ":bind", $user);
$result=ociexecute($s, OCI_DEFAULT);
The last command (ociexecute($s, OCI_DEFAULT); ) can't be executed. Can anyone tell me where am i wrong?
Thanks
FUNCTION GENSECURE RETURN VARCHAR2;
I am trying to call it in PHP with the following code
$sql="begin :bind = GENSECURE; end";
$s = ociparse($c, $sql);
OCIBindByName($s, ":bind", $user);
$result=ociexecute($s, OCI_DEFAULT);
The last command (ociexecute($s, OCI_DEFAULT); ) can't be executed. Can anyone tell me where am i wrong?
Thanks