Hi Sir,
I am struck at my project on the below details. I need your help in this if you can provide I will be thankful to you.
Technical Environment : we are using
Java &
Struts 2, CallableStatement Store Procedure for in order to insert and update. Store Procedure are developed by database team.
I need to insert Table of Objects. Please see the below Store Procedure and my comments in Bold I need to call this GBDF_SAVE_VAR_EQRAGG store procedure in order to insert data using callablestatement In Parameter.
Please give your suggestion how to insert data using Callable Statement which has Table of Objects.
Below Store Procedure.
----------------------------------
create or replace
FUNCTION "GBDF_SAVE_VAR_EQRAGG"
(TipoAzione IN VARCHAR2
,Applicazione IN VARCHAR2
,DataRifChar IN VARCHAR2
,IDSito IN VARCHAR2
,IDAmbito IN VARCHAR2
,IDVar IN VARCHAR2 -- identificativo C_VAR
,DescVar IN VARCHAR2
,SeqVar IN NUMBER
,TabellaVar IN VarCalcTab
,NumeroVar IN NUMBER
,DeltaForz IN NUMBER
,ValoreEqz IN NUMBER
,IDUtente IN VARCHAR2 DEFAULT NULL) RETURN NUMBER
create or replace
TYPE VARCALCTAB AS TABLE OF VarCalcRec ;
create or replace
TYPE VARCALCREC AS OBJECT
( VarSign CHAR(1)
, VarName VARCHAR2(20)) ;