Error calling oracle function with NHibernate

Question

I'm trying to call a oracle function with my c# code using nhibernate, but it throws me this error: ORA-06550: line 1, column 15:\nPLS-00382: expression is of wrong type\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored"}

Here is the function:

CREATE OR REPLACE FUNCTION OID_VAL_MOVIMIENTOS
(
  v_usuario   IN       NUMBER,
  v_archivo   IN       VARCHAR2
)
RETURN NUMBER
AS
  v_cont NUMBER;
BEGIN

  v_cont := 150;
  RETURN v_cont;
END;

here is my hbm.xml file

<sql-query name="ValidaMovimientos">
  {? = call OID_VAL_MOVIMIENTOS(:v_usuario,:v_archivo)}
</sql-query>

And finally this is my c# code:

using (ISession session = NHibernateHelper.OpenSession())
{
    IQuery query = session.GetNamedQuery("ValidaMovimientos");
    query.SetDecimal("v_usuario", idUsuario);
    query.SetString("v_archivo", nombreArchivo);
    object str = query.UniqueResult();
}

I don't know what happend with that...

Jaguar · Accepted Answer · 2011-03-23 17:22:55Z

1

well you should better define the named query

<sql-query name="ValidaMovimientos">
    <query-param name="v_usuario" type="decimal"/>
    <query-param name="v_archivo" type="string"/>
    <return-scalar column="ResultVal" type="decimal"/>
    select call OID_VAL_MOVIMIENTOS(:v_usuario,:v_archivo) as ResultVal
</sql-query>

the select call OID_VAL_MOVIMIENTOS(:v_usuario,:v_archivo) as ResultVal may be syntactically wrong for oracle, modify as needed as my oracle-syntax is rusty

answered Mar 23, 2011 at 17:22

Jaguar

5,95736 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fcartu Over a year ago

I try with a cursor in the function and now its working, but when i try to return an excalar value, it throw me the error above.

Collectives™ on Stack Overflow

Error calling oracle function with NHibernate

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related