error ORA-01010 INVALID OCI OPERATION USING SQL DEVELOPER SOFTWARE.

hello Expert.

I am attempting to connect oracle 7 database hosted on solaris 8 phatform.

i input all the relevant connection information but when i execute the error

message ORA -01010 INVALID OCI OPERATION  is display and fail attempt.

I have a free copy of TOAD software and i am using the same info as above

and i am able to connect and enter the oracle 7 database.

HELP PLEASE

jomfraAsked:
Who is Participating?
 
sujit_kumarCommented:
From http://ora-01010.ora-code.com/

ORA-01010: invalid OCI operation
Cause: One of the following: 1) You attempted an invalid OCI operation. 2) You are using an Oracle client application linked with version 7.1 (or higher) libraries, the environment variable ORA_ENCRYPT_LOGIN is set to TRUE, and you attempted to connect to a version 7.0 (or lower) Oracle Server. 3) You are connected to a version 7.1 (or higher) Oracle Server, the initialization parameter DBLINK_ENCRYPT_LOGIN is set to TRUE, and you attempted to use a database link pointing to a version 7.0 (or lower) Oracle Server. 4) You are connected to a version 9.0.2(or higher) Oracle Server and you attempted to use a database link pointing to a version 9.0.1(or lower) Oracle Server for distributed autonomous transaction.
Action: For the above causes: 1) Do not use the invalid OCI operation. 2) If you do not wish to use encrypted connect passwords in your distributed database, set ORA_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted connect passwords, you must upgrade all Oracle Servers to version 7.1 (or higher). 3) If you do not wish to use encrypted database links in your distributed database, set DBLINK_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted database links, you must upgrade all Oracle Servers to version 7.1 (or higher). 4) Do not attempt distributed autonomous transaction on version 9.0.1(or lower) Oracle Server.
0
 
jomfraAuthor Commented:
hello SUJIT_KUMAR i read your post but i do not follow or understand

I can connect using Toad with same credentials but sql developer

i am not able.

I would like to get to the bottom of this hence i increase the points

thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.