Home » Eclipse Projects » EclipseLink » IN_OUT Parameters not working for NamedStoredProcedureQuery
IN_OUT Parameters not working for NamedStoredProcedureQuery [message #541635] |
Mon, 21 June 2010 21:14 |
Mark Robinson Messages: 6 Registered: June 2010 |
Junior Member |
|
|
I'm trying to use NamedStoredProcedureQuery with IN_OUT parameters.
I have found that if I pass in either null or "" as the value for my IN_OUT then I will get a message returned in the parameter. However if I pass in, say "0", then I will get "0" as a my returned value. Not exactly the results I was hoping for.
Here is the NamedStoredProcedureQuery, am I doing anything wrong?
@NamedStoredProcedureQuery(name = "ADD_ENROLMENT", procedureName = "pkg_enrolment.add_enrolment",
returnsResultSet = false,
parameters = {
@StoredProcedureParameter(queryParameter = "p_enrolment_id", name = "p_enrolment_id", direction = Direction.IN, type=String.class),
@StoredProcedureParameter(queryParameter = "p_v3id", name = "p_v3id", direction = Direction.IN, type=String.class),
@StoredProcedureParameter(queryParameter = "p_v3plan", name = "p_v3plan", direction = Direction.IN, type=String.class), @StoredProcedureParameter(queryParameter = "p_v3careercreatedate", name = "p_v3careercreatedate", direction = Direction.IN, type=Date.class),
@StoredProcedureParameter(queryParameter = "p_spouseid", name = "p_spouseid", direction = Direction.IN_OUT, type=String.class),
@StoredProcedureParameter(queryParameter = "out_errormsg", name = "out_errormsg", direction = Direction.IN_OUT, type= String.class)}
EDIT - Formatting of code to be more readable
[Updated on: Tue, 22 June 2010 16:09] Report message to a moderator
|
|
| | | | |
Goto Forum:
Current Time: Fri Mar 29 08:16:37 GMT 2024
Powered by FUDForum. Page generated in 0.03162 seconds
|