vb.net - How to pass Datatable from vb to Oracle Stored Procedure -


i need pass several rows of data oracle stored procedure , perform multiple operations per row in procedure.
cant seem find proper solution sending datatable.

i had created custom table type in oracle , used parameter of type input param in procedure.
@ vb end directly added datatable parameter.
giving error- cannot convert datatable object.

custom types

create or replace   type forecast_typ object  ( customer varchar2(10 byte),  saleslevel varchar2(3 byte),  serv_loc varchar2(10 byte),  proc_loc varchar2(10 byte),  processed varchar2(15 byte),  prodline varchar2(10 byte),  itemgroup varchar2(10 byte),  qty number, mnth1 date,  customer_desc varchar2(100 byte),  serv_loc_desc varchar2(100 byte),  proc_loc_desc varchar2(100 byte),  itemgroup_desc varchar2(100 byte), pi_desc varchar2(100 byte),  vertical varchar2(50 byte),  steel_type varchar2(100 byte),  pi varchar2(10 byte) )   not final;`  create or replace type forecast_tab_typ table of forecast_typ; 

the procedure declaration this:

create or replace procedure      scdmb000 (   ps_fore_table forecast_tab_typ,   ps_err_code   out   varchar2,   ps_err_var    out   varchar2 ) 

note: donot have problem connecting oracle db m using default data provider comes visual studio 2013. system.data.oracleclient namespace , dot net 3.5.


Comments