Oci-22303 Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter oci-22303: type "sys"."ku$_status1020" not found a title. You can not post a blank message. Please type your
Ude-22303:
message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived
Oci 22303 Type Not Found Oracle
6 Replies Latest reply on Oct 6, 2011 11:33 AM by Helios-GunesEROL Getting error: OCI-22303: type "SYS"."KU$_STATUS1020" not found 890758 Oct 6, 2011 7:05 AM Hi, I need to import
Oci-22303 Type Not Found C#
data in one table using data pump. While doing import i am getting following error... > impdp "'/ as sysdba'" parfile=IMPDP_S_INS_CLAIM_XM.par Import: Release 10.2.0.2.0 - 64bit Production on Thursday, 06 October, 2011 2:48:06 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options UDI-00008: operation generated ORACLE error 22303 OCI-22303: type "SYS"."KU$_STATUS1020" not found Below are the entries in my parfile.. cat IMPDP_S_INS_CLAIM_XM.parCONTENT = ALL DIRECTORY = CBA DUMPFILE = EXPDP_S_INS_CLAIM_XM.DMP LOGFILE = IMPDP_S_INS_CLAIM_XM.LOG REMAP_SCHEMA = SIEBEL:SIEBEL REMAP_TABLESPACE = SIEBEL_DATA07:SIEBEL_DATA07 Please help me in fixing the issue. I have the same question Show 0 Likes(0) 7336Views Tags: none (add) errorContent tagged with error, impdpContent tagged with impdp This content has been marked as final. Show 6 replies 1. Re: Getting error: OCI-22303: type "SYS"."KU$_STATUS1020" not found Helios-GunesEROL Oct 6, 2011 7:10 AM (in response to 890758) Hi; What alert log mention? Please see: IMPDP fails with UDI-00008 OCI-22303 ORA-00600 [kwqbgqc: bad state] [ID 1086334.1] Regard Helios Like Show 0 Likes(0) Actions 2. Re: Getting error: OCI-22303: type "SYS"."KU$_STATUS1020" not found 890758 Oct 6, 2011 7:31 AM (in response to Helios-GunesEROL) Below are the alert log entries at the time of failure... Incremental checkpoint up to RBA [0x79f.1d5.0], current log tail at RBA [0x79f.775.0] Thu Oct 6 02:48:08 2011 The value (30) of MAXTRANS parameter ignored. Thu Oct 6 02:48:16 2011 Errors in file /orasw/DCLMS040/a
reply 6 posts • Page 1 of 1 plsql-table as parameter OCI-22303 Type "..".".." not found by goethals.f » Fri 26 Feb 2010 08:38 Hello, I have a question concerning using plsql-tables in stored procedures as output-paremeters in my oracle packages When executing with dotconnect 5.35.79.0 (non-direct mode) I got the message: OCI-22303: type "user_test"."PCK_XXX.P_XXX_TABLE" not found When executing with dotconnect 5.35.79.0 (direct mode) I got the message about unsupported network datatype (which I believe is indeed a remark on the direct-mode). So this is normal ? When executing my stored procedure in Oracle SQL Developer, it's https://community.oracle.com/thread/2296613 is working. So my procedure/package is OK. Does anyone know what I do wrong, or why it is not working. Why do I get the type-not-found error (I'm connecting with the owner-account). Is there some example-code available which works with plsql-tables with multicolumns and as output-parameter. PS: I got the same errors when trying to execute the procedure directly from with vs.net 2008 with http://forums.devart.com/viewtopic.php?t=17216 OraDeveloperTools 2.55.148 Maybe some extra info My oracle server is 10.2.0.4 64bit My local client is version 8 --> this because we need acces also to older 7.3.4. Could the problem be solved with a oracle 10 client (which cannnot sdaly be installed next to oracle8 client) Fred This is my package code (simplified, and only relevant code, so not 100% complete) PACKAGE user_test.PCK_XXX AS TYPE P_XXX_TABLE IS TABLE OF user_test.XXX%ROWTYPE; PROCEDURE SELECT_DETAILS ( p_Thickness OUT NUMBER, p_ResultSet OUT user_test.PCK_XXX.P_XXX_TABLE ); END PCK_XXX; PACKAGE BODY user_test.PCK_XXX AS PROCEDURE SELECT_DETAILS ( p_Thickness OUT NUMBER, p_ResultSet OUT user_test.PCK_XXX.P_XXX_TABLE ) AS BEGIN -- Normal PL-SQL code to create cursor: tmp_p_ResultSet -- tmp_P_rec is record of rowtype of table to fetch LOOP FETCH tmp_p_ResultSet INTO tmp_P_rec; EXIT WHEN tmp_p_ResultSet%NOTFOUND OR tmp_p_ResultSet%NOTFOUND IS NULL; -- Add to table tmp_Total := tmp_Total + 1; p_ResultSet.EXTEND;p_ResultSet(tmp_Total).FIELD1 := tmp_P_rec.FIELD1;p_ResultSet(tmp_Total).FIELD2 := tmp_P_rec.FIELD2; -- MORE different FIELDs END LOOP; CLOSE tmp_p_ResultSet; END SELECT_DETAILS; END PCK_XXX; goethals.f Posts: 60Joined: Mon 18 May 2009 13:17 Top by StanislavK » Fri 26 Feb 2010 14:34 This is the expected behaviour. In the Direct mode, you get an exception as Oracle objects are no
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Get OCI-22303 error message when try to view contents of Oracle 9i table Want to Advertise Here? Solved Get OCI-22303 error message when try to view contents of Oracle 9i table Posted on 2004-11-23 Oracle Database 1 Verified Solution 7 Comments 1,120 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 Question by:blockwood20 Facebook Twitter LinkedIn Google Best Solution bymodulo PAQed with points refunded (250) modulo Community Support Moderator Go to Solution 6 Comments LVL 5 Overall: Level 5 Oracle Database 2 Message Expert Comment by:SMartinHamburg2004-11-23 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 Message Author Comment by:blockwood202004-11-23 There were no error messages when importing the table. The user types appear in the schema after