| IN_OUT Parameters not working for NamedStoredProcedureQuery [message #541635] |
Mon, 21 June 2010 17:14  |
Eclipse User |
|
|
|
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 12:09] by Moderator |
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04366 seconds
Home