Eclipse Community Forums: EclipseLink » @NamedStoredProcedureQuery & Out Parameter:

Home » Eclipse Projects » EclipseLink » @NamedStoredProcedureQuery & Out Parameter:(I am trying to call a procedure with 2 parameters of type IN , and Out. but getting exception.)

@NamedStoredProcedureQuery & Out Parameter: [message #652412]

Thu, 03 February 2011 14:16

Eclipse User

I am getting following exception:

PLS-00306: wrong number or types of arguments in call to 'TLD_CO_POWER_SITE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Code:

@NamedStoredProcedureQuery(
name = "loadQuery",
procedureName = "SITE",
returnsResultSet = false,
resultClass = CSite.class,
parameters = {
@StoredProcedureParameter(queryParameter = "Code", direction = Direction.IN),
@StoredProcedureParameter(queryParameter = "Type", direction = Direction.OUT)}

@StoredProcedureParameter(queryParameter = "Loc", direction = Direction.OUT)}

and:----

Query q = em.createNamedQuery("loadQuery");
q.setParameter("iCode", "STTLWA06");
CSite xyz = (CSite) q.getSingleResult();

Can somebody Please help??

Re: @NamedStoredProcedureQuery & Out Parameter: [message #652558 is a reply to message #652412]

Fri, 04 February 2011 09:23

Eclipse User

duplicate post of
http://www.eclipse.org/forums/index.php?t=msg&th=204031& amp;start=0&S=e8c4d9d34b457c8fa843c1a63a7d721a

Previous Topic:	Discriminator value and char trimming problem
Next Topic:	OSGI WAB problem with persistence.xml

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 11:12:53 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter