Re: Bulk inserts, PL/SQL and ODBC

So what are your params to the SP? What types are you passing?

BTW - bulk loading is better accomplished using SQL*Loader.

rr

jmilushe_at_my-dejanews.com wrote:

> Can anyone help with this problem?
>
> Has anyone tried to use bulk inserts through ORACLE ODBC 8.0.5 in a Oracle8
> database?
>
> I am trying to do bulk inserts calling a stored procedured which has input
> parameters PL/SQL tables. In this way I am trying to pass arrays of values to
> be inserted into the database tables in one ODBC call.
>
> Unfortunaetly I get this error after SQLExecDirect: ORA-6550 line 1 col 7
> PLS-00306: wrong number or types of arguments in call to func_name
>
> If anyone has had similar problems or could suggest another way of doing it I
> would appreciate it a lot.
>
> The ODBC drivers are Oracle ver. 8.0.5.0.0
> I am using Vicual C++ 5.0
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Wed Apr 14 1999 - 08:23:13 CDT