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

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 14:23 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1389
Registered: July 2009
Senior Member
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:
  


Current Time: Fri Mar 29 00:24:12 GMT 2024

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

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

Back to the top