• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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)) ;
 
reply
    Bookmark Topic Watch Topic
  • New Topic