Calling a function from VB/ADO returns ODBC error

From: Fredrik Lilja <fredrik.lilja_at__NOSPAM_iconmedialab.se>
Date: 2000/04/28
Message-ID: <FQK18dSs$GA.238@news.iconmedialab.se>#1/1

I have a function (in a package) which takes 18 inparamaters (NUMBER and VARCHAR2) and
INSERTs this data into a table in the database. I can run the function from SQL Navigator (which is a 3rd part client tool which can run SQL-scripts)
but when I call this function from a Visual Basic application I'm developing (ADO/ODBC) I get this
error message from the ODBC driver: "[Oracle][ODBC]Syntax error or access violation"
The connection and command object in ADO/VB is correct because it workes when I'm calling other functions (which
takes fewer parameters...) in the Oracle database.

Do you have a clue what "[Oracle][ODBC]Syntax error or access violation" means or some tips on
what I should do to debug this problem ?

Regards

Fredrik Lilja
Icon Medialab
http://www.iconmedialab.se Received on Fri Apr 28 2000 - 00:00:00 CDT