I was pretty much pleased with the way we were progressing. I was using this method for testing procedures from toad to see responses from ref cursors:
http://heather.koyuk.net/refractions/?p=343
And then one fine day i was playing around with some Toad options and boom! The procedure executions with ref cursor host variables would simply not work!
I would get a ORA-1866 i think that pretty much said the no. of type of arguments in the call were incorrect.
And next day i went back to inspect where that option was in TOAD to enable it to prompt me for host variable substitution. the attached screenshot shows where it is.
So get writing pl/sql with ref cursors people! ;-)
http://heather.koyuk.net/refractions/?p=343
And then one fine day i was playing around with some Toad options and boom! The procedure executions with ref cursor host variables would simply not work!
I would get a ORA-1866 i think that pretty much said the no. of type of arguments in the call were incorrect.
And next day i went back to inspect where that option was in TOAD to enable it to prompt me for host variable substitution. the attached screenshot shows where it is.
So get writing pl/sql with ref cursors people! ;-)
No comments:
Post a Comment