Re: Oracle Execute Function

Brad Bonkoski wrote:

Brad Bonkoski wrote:

Roman Neuhauser wrote:

# bbonkoski@mediaguide.com / 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/