[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Get OCI-22303 error message when try to view contents of Oracle 9i table

Posted on 2004-11-23
7
Medium Priority
?
1,154 Views
Last Modified: 2008-01-09
Hi,

I have imported a table from my home computer running Oracle 9i to the corporate computer running Oracle 9i.  The table contains two user defined types.  When I try to access the contents of the table using Keeptools Hora, i get the message OCI-22303.  The table works fine at home.  Any suggestions?

Thanks,
Brent
0
Comment
Question by:blockwood20
6 Comments
 
LVL 5

Expert Comment

by:SMartinHamburg
ID: 12659743
Any error messages when importing the table ?
Don't know keeptools hora - can it handle user defined types ?
Can you access the table using plain ol' SQLplus ?
Don't have my manuals at hand, just googeled for OCI-22303 -
seems to be "type not found" related error ...
If you just exported/imported the table and not the whole schema
maybe you will have to define your user defined type on your company
database.
More questions than answers - hope it helps you somewhat ...
Regards
0
 

Author Comment

by:blockwood20
ID: 12659934
There were no error messages when importing the table.  The user types appear in the schema after the import.  Hora can handle user defined types.  I can access the table with SQLplus but I don't get the results that I get with the Hora that works at home.  Yes, OCI-22303 is a type not found related error.  
I tried just building an empty table and when I went into Hora I got the same message when trying to view the contents.  At home I can go into the empty table and add rows.

Any other suggestions?
Brent
0
 
LVL 5

Expert Comment

by:SMartinHamburg
ID: 12660146
hmm. Anything differnet in the environment at home vs. company (user profile, privileges, roles, datbase
versions etc.) ?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 6

Expert Comment

by:Eladla
ID: 12661123
Have you also exported and imported the user datatypes?

It looks like the error is due to unknown data types.
0
 

Author Comment

by:blockwood20
ID: 12668161
As it turns out the problem was the version differences.  The database is Oracle 9i.  But the workstation that I was running Hora from had an Oracle 8i client installed.  I installed Hora on a machine with 9i and the problem is resolved.

Thanks everyone for your input.

Brent
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14134209
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses
Course of the Month19 days, 9 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question