I'm trying to execute an Oracle stored proc using NHibernate 1.2 CR1. I've had a good look around, but am finding it hard to find an example of exactly how to do this.
Does the bug referenced at the bottom of this thread:
http://forum.hibernate.org/viewtopic.ph ... 7d3e2e43dc
and the discussion in the four threads linked, mean that it is effectively not possible to currently call oracle stored procedures?
I'm trying to call an oracle stored procedure that has a ref cursor as its output parameter, but am unsure how to specify the location/name/type etc. of this.
The proc takes a total of 5 params and if I specify (using SetString) 4 I get an error saying:
ORA-06553: PLS-306: wrong number or types of arguments in call
If I specify the output param as ? but don't set it to anything (What should I set it to?) I get the following error.
Not all positional parameters have been set. Expected 1, set 0.
Basically, is it currently possible to call oracle stored procs with a cursor as output using NHibernate1.2.CR1? If so, how? If not, will this be implemented before NHibernate 1.2 goes to full release?
Login
FAQ
Search
