Is it possible to receive Oracle Object Type as an output from stored procedure? (java.sql.Types STRUCT)
Hello everyone!
I am writing a SQL CALL (using JDBC) to a stored procedure that outputs a structured object (Oracle Object).
However, the adapter method is not accepting the corresponding JDBC Data Type STRUCT for the output parameter, returning the following error:
ERRO #5023: Erro no Gateway Remoto: JDBC Gateway SP execute(0) error 0: Remote JDBC error: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'AGUARDAR_EVENTO'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Declaration of Output parameter:
Set tParams(1, "SqlType") = $$$SqlJStruct
Set tParams(1, "IOType") = $$$SQLPARAMOUTPUT
According to the documentation, STRUCT Interface has not been implemented yet:
To retrieve a parameter typed as an Oracle Object, would I have to implement this interface as well?