Error java.sql.SQLException Type de colonne non valide

[pcouas]

Hi,

 

I have following error message Error java.sql.SQLException Type de colonne non valide

From IReport i use

{call DP_LO_GRAPH._GET_GRAPH_BY_VESSEL7($P{ORACLE_REF_CURSOR})}

My store proc is PROCEDURE P_GET_GRAPH_BY_VESSEL7(v_refcur OUT sys_refcursor)

I using oracle10 Express Edition

 

Regards

Phil

[pcouas]

ORACLE_REF_CURSOR is not available into parameters list ??

I have added it manually ??

type type java.sql.ResultSet is not available from available type

 

 

My procedure is fine running from SQL_DEVELOPPER
variable rc refcursor;
--_exec my_proc( :rc );
exec DP_LO_GRAPH.P_GET_GRAPH_BY_VESSEL7( :rc );
print rc