Oracle DB Conection

mars2508 · **Posted:** Wed May 18, 2005 10:31 am

I'm trying to connecto to a Oracle DB vía OBDC but I have the next error: May 18 11:10:29.52: [9] DB Connect May 18 11:10:29.52: ConnectString: DSN=OPENBANK;UID=ivr;PWD=ivrd May 18 11:10:31.04: SQL Error State: 01000 Native Error Code: 0 ODBC Error: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). May 18 11:10:31.06: SQL Error State: HYC00 Native Error Code: 0 ODBC Error: [Oracle][ODBC Oracle Driver]Driver not capable.

Chris · **Posted:** Wed May 18, 2005 10:42 am

Does the next line say 'FAILURE'? If it doesn't, don't worry about it. These "errors" are returned from the ODBC driver, but are not necessarily indicative of a major problem. If you can successfully query the database in spite of these errors, continue working with you application and don't worry about it.

mars2508 · **Posted:** Wed May 18, 2005 10:50 am

You are right, the next line doesn't say 'FAILURE', but I'm invoking a Stored Procedure into a Fetch Step and I also have this error: May 18 11:49:57.60: [11] SQL Fetch May 18 11:49:57.60: ERROR: No SQL statement defined May 18 11:49:57.60: FATAL May 18 11:49:57.60: Attempting to jump to Fatal Error Global Event label: '' May 18 11:49:57.60: Fatal label undefined! May 18 11:49:57.62: Shutting down...

mars2508 · **Posted:** Wed May 25, 2005 3:29 pm

I didn't find any response from you... Could you help me with my problem?

admin · **Posted:** Wed May 25, 2005 4:00 pm

Hi mars2508, Please see the forum discussion here: <a href="http://devnet.engenic.com/index.php?action=vthread&forum=10&topic=248 " target="_new">http://devnet.engenic.com/index.php?action=vthread&forum=10&to pic=248 </a> It discusses the correct way to call a stored procedure within a SQL Statement.

mars2508 · **Posted:** Thu May 26, 2005 8:48 am

It still doesn't work... I write it in this way: EXECUTE my_procedure (@USUARIO,@CUENTA,@RESULTADO,@SALDO); Where @USUARIO,@CUENTA,@RESULTADO,@SALDO are local variables… Do I have to use something else apart of a DB Connect, a SQL Statement, a SQL Fetch and a SQL End?

admin · **Posted:** Thu May 26, 2005 8:51 am

Have you quoted string values?

mars2508 · **Posted:** Wed Jun 08, 2005 1:42 pm

Yes I have...

Chris · **Posted:** Wed Jun 08, 2005 3:19 pm

Does the SQL Fetch step have the same handle number as the SQL Statement step you are using to define the stored procedure? They should have a number from 1-9, and they should be the same number. Does your stored procedure return its data in fields?