Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting data in database having Table Of Objects using store procedure callablestatement

 
PadamSonu Dhariwal
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)) ;
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic