Odtnhj

I am trying to call an stored procedure with JPA. When I call testWithNumber from serviceImpl, it works fine, but when I call testWithType, it throws the error:

javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: Error calling
CallableStatement.getMoreResults

PLS-00306: wrong number or types of arguments in call to 'TESTWITHTYPE'

There is a way to call a stored procedure which has parameters of a custom TYPE?

Database procedures inside same package (PKG_TEST):

PROCEDURE testWithNumber (idName IN NUMBER, nameFound out VARCHAR2)
IS
BEGIN 
 SELECT NAME INTO nameFound FROM NAMES_TABLE WHERE ID_NAME=idName;
END test;

PROCEDURE testWithType (nameParam IN TEST_TYPE, nameFound out VARCHAR2)
IS
BEGIN 
 SELECT NAME INTO nameFound FROM NAMES_TABLE WHERE ID_NAME=nameParam.idName;
END test;

The TEST_TYPE in database is like this:

create or replace TYPE TEST_TYPE FORCE AS OBJECT 
( 
ID_NAME NUMBER(22)
,
NAME VARCHAR2(100)
);

Service implementation:

@Override
public void testWithType(NameDto nameObject) 

 StoredProcedureQuery query = em.createStoredProcedureQuery("PKG_TEST.testWithType")
 .registerStoredProcedureParameter(1, NameDto.class, ParameterMode.IN)
 .setParameter(1, nameObject)
 .registerStoredProcedureParameter(2, String.class, ParameterMode.OUT);

 query.execute();
 LOG.info(query.getOutputParameterValue(2));


@Override
public void testWithNumber(NameDto nameObject) 

 StoredProcedureQuery query = em.createStoredProcedureQuery("PKG_TEST.testWithNumber")
 .registerStoredProcedureParameter(1, Long.class, ParameterMode.IN)
 .setParameter(1, nameObject.getIdName())
 .registerStoredProcedureParameter(2, String.class, ParameterMode.OUT);

 query.execute();

 LOG.info(query.getOutputParameterValue(2));
 

The NameDto class:

import java.io.Serializable;
import java.util.Date;

public class NameDto 

 Long ID_NAME;
 String NAME;

 public NameDto(Long iD_NAME, String nAME) 
 super();
 ID_NAME = iD_NAME;
 NAME = nAME;
 

 public Long getID_NAME() 
 return ID_NAME;
 

 public void setID_NAME(Long iD_NAME) 
 ID_NAME = iD_NAME;
 

 public String getNAME() 
 return NAME;
 

 public void setNAME(String nAME) 
 NAME = nAME;