Re: ODBC drivers

Thanks for the reply.

I have found the problem - it is a carriage return at the end of the command. When I connect using the ODBC test program, provided by Oracle, and type just the command:

begin my_proc('-1', 'INT_TEN_RS', 1); end;

it works. But if I hit enter at the end of the line, I get the error. The carriage return does not make any difference when I use the old or Microsoft's driver but makes a difference with the 8.1.6 ODBC driver.
Also the carriage return only causes a problem when you execute a stored procedure. If you run a SELECT, INSERT, etc statements, it does not make any difference whether the carriage return is there or not.

Thanks for the info anyway, I did not think about the DSN option.

Witold

> I think your problem is the MS Transaction Server. Configure your DSN an=
d
> click checkbox "Disbale MTS Support". I think this should work.
>
> Regards
>
> Volker Sch=F6n
> E-Mail: mailto:v.schoen_at_inplan.de
> http://www.inplan.de
>
>
>
> -----Urspr=FCngliche Nachricht-----
> Von: Witold Iwaniec [mailto:wiwaniec_at_novalistech.com]
> Gesendet: Dienstag, 5. September 2000 16:45
> An: Multiple recipients of list ORACLE-L
> Betreff: ODBC drivers
>
>
> Hi
>
> I have strange behavior of ODBC drivers and wonder if anyone else
> noticed it, knows fix for it. Here it goes:
>
> I have a stored procedure that takes three parameters VARCHAR2,
> VARCHAR2, NUMBER
> the call through ODBC would be, for example,:
>
> begin my_proc('-1', 'INT_TEN_RS', 1); end;
>
> I connect to Oracle 8.1.6 database on Sun Solaris from Windows
> NT 4.0 SP 5. When I use Microsoft ODBC driver or old Oracle
> ODBC driver (Oracle 73 ver 2.5) it works. But when I use Oracle
> ODBC driver installed with Oracle 8i client (ver 8.01.06.00)
> sometimes it works but in most cases it returns error 6550 with the
> message:
> line1, column 64: PLS-00103: Encountered the symbol "" The
> symbol "" was ignored.
>
> I would look into the procedure but it works with other drivers, as
> well as with OCI etc.
>
> Has anyone worked with the driver?
Received on Wed Sep 06 2000 - 06:32:35 CDT