|Think about Loose Coupling|
Re: How to call Oracle stored procedures?by ant (Scribe)
|on Nov 01, 2006 at 16:16 UTC||Need Help??|
Thanks for the replies, I Have delved even deeper into this, and it turns out that to get this working the way I want to, I have to call a oracle stored procedure and get it to return a Oracle cursor.
Therefore part of my code in the main program now looks like this.
and in my database module, the run_query code looks like this
The second parameter that I'm binding is the OUT parameter as well as being of type CURSOR, which is why it also needs a few more parameters in the bind_param_inout call (line 52 in module).
However The error message I now recieve is
Can't bind :p2, ora_type 0 not supported by DBD::Oracle at Database.pm line 52.
Any further suggestions would be great.
PS, pl/sql code looks like this