Brad Bonkoski wrote:
Brad Bonkoski wrote:
Roman Neuhauser wrote:
# bbonkoski@xxxxxxxxxxxxxx / 2007-01-18 11:46:10 -0500:
Hello All,
I have this Oracle function, and within my code I call it like this:
$sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null,
null, null); END;";
$stmt = $db->parse($sql);
$rc = null;
ocibindbyname($stmt, ":result", &$rc);
$db->execute($stmt, $sql);
The problem is that the execute function spits back an error/warning
message, but the Oracle function properly executes and the data is
in the Database.
And the warning is...?
Nothing of real use from what I can see..
It falls into this statement:
die('Invalid Statement: ' . $stmt .'('.$query.')'. ' ' .
htmlentities($error['message']));
So, I get this message back (and the error['message'] part is blank.
It gets there from this:
$result = @ociexecute($stmt);
if(!$result) {
...
}
so the return from ociexecute appears to be FALSE.
After removing the '@' from the ociexecute ... I get this:
PL/SQL: numeric or value error: character string buffer too small
Does this trigger any ideas?
Sounds like an issue with your function. Does it work ok outside of php?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
