Oracle named procedure

SickFuck · **Joined:** Fri Oct 21, 2011 9:20 am **Posts:** 3

HELLO.

I know that this subject was mentioned before, but i did not find any real answer.
I'm creating a named procedure in nhibernate xml:

<sql-query name="GetSysVal">
<return class="Person">
<return-property name="LastName" column="Value" />
</return>
{call GetOptValue(?,'xxx' ,null,null,null) }
</sql-query>

When a call proc in c# code like this:

String result = hqlSupport.Session.GetNamedQuery("GetSysVal").UniqueResult<String>();

I receve a following error:

Expected positional parameter count: 1, actual parameters: [] [{call GetOptValue(?,'xxx' ,null,null,null) }]

Can anyone tell me whats wrong with tis implementation?
BTW Nhibernate ver. 3.1.something Oracle DB 10 g

PLEASE HELP!!!

enilag · **Joined:** Thu May 03, 2012 10:20 pm **Posts:** 4

Share information!

diego.torres.fuerte · **Joined:** Fri Apr 27, 2012 6:23 pm **Posts:** 3

I think you should use something like call GetOptValue(@LastName,'xxx' ,null,null,null). Take a look @ this calls in my code to mysql store procedures, may be something here can make sense for you:

Code:

...
Dim objCommand As New MySqlCommand()
objCommand.Connection = objConnection
objCommand.CommandText = "call read_person_images(@p_personID)"
objCommand.CommandType = CommandType.Text

objCommand.Parameters.Add("@p_personID", MySqlDbType.Int64).Value = personID

Dim objAdapter As New MySqlDataAdapter(objCommand)
Dim objDataResult As New DataSet

objAdapter.Fill(objDataResult)
...