Bulk inserts, PL/SQL and ODBC

From: <jmilushe_at_my-dejanews.com>
Date: Tue, 13 Apr 1999 20:33:04 GMT
Message-ID: <7f09m0$ko9$1@nnrp1.dejanews.com>

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 Tue Apr 13 1999 - 15:33:04 CDT