Home » SQL & PL/SQL » SQL & PL/SQL » Problem with odbc
Problem with odbc [message #240543] Fri, 25 May 2007 03:24 Go to next message
jfigueiredo
Messages: 4
Registered: May 2007
Junior Member
Hi i am having this problem when connecting do odbc drive for acucobol, my oracle version is 9i:

SQL*Plus: Release 8.0.6.0.0 - Production on Fri May 25 0

(c) Copyright 1999 Oracle Corporation. All rights reser

ORA-01010: invalid OCI operation
ORA-01010: invalid OCI operation
ORA-01010: invalid OCI operation
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Server not available or version too low for this feature
ORA-01010: invalid OCI operation

Connected to:
Oracle Open Client Adapter for ODBC 6.0.5.29.0
VISION 05

SQL> select * from control;
SQL*Plus internal error state 2090, context 18:0:0
Unsafe to proceed

Please tell me what to do i musta connect via odba to cobol
thanks in advance

Pedro Figueiredo
Re: Problem with odbc [message #240625 is a reply to message #240543] Fri, 25 May 2007 06:26 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
What is odba? Do you mean ODBC? If so, why don't you just connect to SQL*Plus natively?
Re: Problem with odbc [message #240633 is a reply to message #240625] Fri, 25 May 2007 06:36 Go to previous messageGo to next message
jfigueiredo
Messages: 4
Registered: May 2007
Junior Member
Hi,
yes what i mean is odbc the problem that i have is when connecting to acuodbc and make a select statement the errors is:

SQL> select * from control;
ERROR:
OCA-30027: error setting ODBC connection/statement option



no rows selected

but i can do delete, insert or update.

Re: Problem with odbc [message #240649 is a reply to message #240633] Fri, 25 May 2007 07:22 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read this
Previous Topic: optimize this procedure..
Next Topic: I'm ignorant and stubborn - Answers my queries.
Goto Forum:
  


Current Time: Sat Dec 10 22:13:57 CST 2016

Total time taken to generate the page: 0.08510 seconds