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

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?

October 10th, 2009, 02:31 PM

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 });