Re: Calling a function from VB/ADO returns ODBC error

I have identified the problem to occur when I have a string value which contains
the "@" character in the command text.
For example: PKG_COMPANY.COMPANY_SET (1,'Acme Inc.','info_at_acme.com') DoewAnyone knows how to code the @ character in a command text so the Oracle ODBC driver
doesn't return an error ?

/Fredrik Lilja (again)

Fredrik Lilja <fredrik.lilja@_NOSPAM_iconmedialab.se> wrote in message news:FQK18dSs$GA.238_at_news.iconmedialab.se...
> 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