Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00022: invalid session id; access denied

user489331Feb 28 2006 — edited Feb 28 2006
hi everybody
i need your help
when i connect Access database from oracle 8i thru odbc
as connect a/a@odbc:db_ac then it show message
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
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-00022: invalid session id; access denied
Connected.
SQL>
but when i run this command it sho error as
SQL> COPY FROM A/A@ODBC:DB_AC TO newton/nds@orcl INSERT EMP1 USING SELECT F1,F2,F3,F4,F5,F6,F7,F8 FROM EMP1;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
ORA-00022: invalid session id; access denied

ERROR:
OCA-00022: general OCA error
plz help
with thanx
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2006
Added on Feb 28 2006
1 comment
4,924 views