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
Post a Comment