0

I'm trying to call a stored procedure on an oracle DB , I did create entity and repo for the procedure , however , when i initiate the call I get "java.lang.NullPointerException" ... please note that I do have another procedure within the same project which is working fine ..

Entity:

@NamedStoredProcedureQuery(name = "MsgEntity.submitMsg", procedureName = "PROC_SUBMITMSG", parameters = {
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "PARAM1", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "PARAM2", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "PARAM3", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "PARAM4", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "PARAM5", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.OUT, name = "RESULT1", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.OUT, name = "RESULT2", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.OUT, name = "RESULT3", type = String.class)}

Repo:

    Map<String, String> submitMsg(@Param("PARAM1") String PARAM1,
                                  @Param("PARAM2") String PARAM2,
                                  @Param("PARAM3") String PARAM3,
                                  @Param("PARAM4") String PARAM4,
                                  @Param("PARAM5") String PARAM5,);

Call:

Map<String, String> smsBillResponse = smsRepository.submitMsg("value1","value2","value3","value4","value5");

Log: ERROR [org.springframework.boot.web.servlet.support.ErrorPageFilter] (default task-1) Forwarding to error page from request [/foo/fooo/foooo] due to exception [null]: java.lang.NullPointerException

I did try to call the procedure directly on the DB using DBeaver and it's working fine ..

AzamAld
  • 1
  • 1

0 Answers0