Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 19:16 Go to next message
Azhar Sikander is currently offline Azhar SikanderFriend
Messages: 4
Registered: February 2011
Junior Member
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


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)}


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 14:23 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1342
Registered: July 2009
Senior Member
duplicate post of amp;start=0&S=e8c4d9d34b457c8fa843c1a63a7d721a
Previous Topic:Discriminator value and char trimming problem
Next Topic:OSGI WAB problem with persistence.xml
Goto Forum:

Current Time: Tue Apr 07 10:47:33 GMT 2020

Powered by FUDForum. Page generated in 0.01961 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top