Re: ODBC Driver Errors to Store procedure

Hey Golden !
I believe that this is a bug on the Oracle ODBC driver ! And it seems that no one helps on this subject, I posted the same question on all the newsgroups that I could find and until now nobody has anwered !

R

Pedro Ramos

goldenge_at_my-dejanews.com wrote:

>Hello, Help me please! I work with Oracle v8.0.3(or v8.0.4) for Win NT
>server4.0. I use the Microsoft Visual Foxpro 5.0 and with the Oracle ODBC
>Driver(Version 8.0.3. Version 8.0.4.0, Version 8.0.4.0.1, Version 8.0.4.0.2
>all download from oracle web site) to connect to the Oracle database server.
>I create a store procedure or trigger from the Foxpro with ODBC connect. If
>there are some return code in the statement, then the store procedure or
>trigger will be compile errors. But when I use the Intersolv Data connect
>ODBC Driver for Oracle 8. It can work correct. Following are some steps:
>Assume ODBC datasource : gold In Foxpro: ?sqlconnect('gold','gold','gdi')
>---- return 1 ?sqlexecute(1,'create store procedure sp_xxx') ---- The
>statement with return code (od0a). This operation will return -1 The error
>messages is : Connectivity error: [Oracle][ODBC][Ora]Trigger, procedure or
>function created with PL/SQL compilation error(s).

> But when I change the connection use the Intersolv odbc driver , it will
>run correctly.
> Also, this statment can run in Oracle worksheet correctly.

> Please help me . Our products must work with foxpro and actively create the
>store procedure and trigger in foxpro enviroment and through the Oracle odbc
>dirver, sent the store procedures and triggers to database server.

> Thanks.
> Golden Ge
> Email: goldenge_at_chinasystems-cn.com

>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Oct 01 1998 - 18:45:06 CDT