Re: Oracle Execute Function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux