PDA

View Full Version : Oracle and Perl don't play nice



slakkie
October 8th, 2009, 04:18 PM
Code + error log here: http://pb.opperschaap.net/63

The problem is (at least that is my assumption) that the function/procedure I'm calling is overloaded:

one is name_of_thing(int, int);
the other is name_of_thing(int,varchar2);

I think Oracle has problems deciding which one it should prepare and takes the wrong one.

Does anyone has some insight in how to fix this problem?

slakkie
October 10th, 2009, 02:31 PM
*bump*

slakkie
October 12th, 2009, 11:07 AM
Fixed the issue.



# Causing the error
sth->bind_param(2, $queue, { TYPE => ORA_NUMBER });
# Fixing the error
$sth->bind_param(2, $queue, { ora_type => ORA_NUMBER });