i have common procedure with 12 parameter, these procedure calling other procedure with limited procedure,
i m using this procedure in vba excel application, in excel i m using oracle oledb provider connection and using ado command
in ado connection does not execute procedure like native style "begin proc_name(para1=> para_value1,para2=>para_value2... ); end;
wich is support is msdora provider,how can i do same though oraoledb ado command, now ole require all parameter require with seqence mentain,
also there is not any parameter maping command like p_for_comp => 12,p_for_emp=58, how can i do same as plsql native syntax
plz update me on my id
cngchetan@gmail.com