Oracle ORA-06553: PLS-553: character set name is not recognized

Sir,Following message is comming when we try to export database from DOC promt: Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setserver uses JA16EUC character set (possible charset conversion)About to export the entire database .... exporting tablespace definitions. exporti ...

How to solve ORA-06553: PLS-561 error?

When I run exp command and want to export a db, there are some errorsinfomations displayed is below:. exporting synonymsEXP-00008: ORACLE error 6553 encounteredORA-06553: PLS-561: character set mismatch on value for parameter'SHORTNAME'EXP-00000: Export terminated unsuccessfullyCould you tell me why ...

Oracle exp error ORA-06553: PLS-561

I Obtain this error when I use exp to backup my db in oracle 8.1.6. on Red Hat 6.2EXP-00008: ORACLE error 6553 encountered ORA-06553: PLS-561: character set mismatch on value for parameter 'SHORTNAME' EXP-00000: Export terminated unsuccessfully NLS_LANG is defined as follow.NLS_LANG=AMERICAN_AMERICA ...

Oracle ORA-06553: PLS-123: program too large on import

I import a dump file from a 9.2.0.4 to an other 9.2.0.4 database.On some importing table, I have this error :. . importing table "PS_TL_PAYABLE_HIST" 0 rows importedIMP-00017: following statement failed with ORACLE error 6540:"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL : ...

Oracle Error Accessing Package -ORA-06553: PLS-213

This may be simple for someone out there, so pls help...I get the following error when i access SQL*PLUS Error accessing package DBMS_APPLICATION_INFOERROR:ORA-06553: PLS-213: package STANDARD not accessibleAny advise or solution is welcome. ...

Oracle ERROR : ORA-06553 PLS-213

i have ora8i db and now its have problem.I run script "CATEXP.SQL" under user sys,which i connect db again,i can connect its but it have some error such as Error accessing package DBMS_APPLICATION_INFO Error : ORA-06553:PLS-213: Package STANDARD not accessable ...

ORA-06553: PLS-801: internal error [56319]

I have the following errors when trying to use Oracle. Oracle is installed on Aix 4. Besides the errors I was able to create users, tablespaces ... The problem arrived when I tried to drop a user or a table (using the system user). Since I need to drop some users I am blocked.I will be very thankful ...

Oracle ORA-06553: PLS-561 character set mismatch on value for parameter xxxx

We have Oracle 8.1.6 on Unix, with NLS_CHARACTERSET=US7ASCII and NLS_NCHAR_CHARACTERSET=US7ASCII.Recently we had to change character set to WE8ISO8859P1 (ISO 8859-1 West European).We took the following steps:1. UPDATE sys.props$ SET value$ = 'WE8ISO8859P1' WHERE name = 'NLS_CHARACTERSET'2. COMMIT3. ...

Oracle ERROR ORA-06553:PLS-707

AFTER MIGRATION FROM 8.1.5 TO 8.1.7 VERSION USING WIZARD MIGRATION,THE MESSAGE ORA-06553:PLS-707 INTERNAL ERROR [2603] IS CONSTANT ON QUERYSnull ...

Oracle ERROR ORA-06553:PLS-707

AFTER MIGRATION FROM 8.1.5 TO 8.1.7 VERSION USING WIZARD MIGRATION,THE MESSAGE ORA-06553:PLS-707 INTERNAL ERROR [2603] IS CONSTANT ON QUERYSnull ...

ORA-06553: PLS-213: package STANDARD not accessible

My company's database has been working for months, then today, I was executing some procedure that'll enable flashback for a session. Then I ran a 'flashback table ..' command (which didn't work since 'feature wasnt enabled').Anyhow after a while, I noticed the error 'ORA-06553: PLS-213: package STA ...

Oracle ORA-06553:PLS-707 error

I tried upgrading from 8.1.6 to 8.1.7 on my new Pentium 4 box and am now receiving the below error when I log into SQL*. Is anyone familiar with this one?ORA-06553:PLS-707 error: unsupported construct or internal error[2603]. ...

ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or m

below is my stored procedure and it gives the following error:PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminatedORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformedThe query when run on its own seems fine and gives the correct results.but when it ...

Oracle Replication:Ora-06553 Pls-273:Package standard not accessible

Hello, I have a problem. When I try to create a Replication (of the database) Oracleshow me this msg:"ORA-06553 pls-273:Package standard not accessible."I entered in the database as administrator and I have all permissions (grant).What I can do to resolve this problem? ...

Oracle ORA-06553: PLS-561: character set mismatch on value for parameter 'STR1'

ORA-06553: PLS-561: character set mismatch on value for parameter 'STR1'Some reports started failing that had previously worked ok; they gave the above error. We are unaware of any database or code changes that might have triggered this and there is nothing in the alert log or the trace directories ...

Oracle 9i ORA-06553: PLS-213: package STANDARD not accessible

I am running Oracle 9i 9.0.1.0.1 under Windows 2000 for a while without any problem up to now. I am receiving the following error when I run SQL Plus:ERROR:ORA-06553: PLS-213: package STANDARD not accessibleERROR:ORA-06553: PLS-213: package STANDARD not accessibleError accessing package DBMS_APPLICA ...

Oracle ORA-06553: PLS-123: Program too large

I have 2 databases, the development database (9i) and pruction database (10g). I have the same programs on the databases, but when I try to execute the package1.program1 for 3000 records in 10g, result in a error:ORA-06540: PL/SQL Compilation errorORA-06553: PLS-123: Program too large9i is OK.The pr ...

Oracle ORA-06553: PLS-707: and catalog/catproc help

I recently had to apply an Oracle patch (patchset 3820881) to 3 Oracle Instances (8.1.7.4)(these instances reside on the same server and use the same oracle home).During the copying over of the patch files - the some dll files were not copied over due to a process using them.Before I copied the file ...

Oracle ORA-06553: PLS-213: package STANDARD not accessible

I encounter the subjected error when I do the following.1. shutdown xe database.2. create a new database hil (no error messages)3. delete instance xe by oradim4. create and startup instance hil by oradim 5. modify listener.ora and tnsnames.ora, start listener to listen to hilAfter the above steps, I ...

Oracle ORA-06553: PLS-908: The stored format of <package> is not supported

We have migrated one database from 8i to 9i and the other database is still on 8iI have tried to recompile a user defined package in oracle 8i which is calling package in 9i and i got the following error:ORA-04052: error occurred when looking up remote object <package name>@<dblink>ORA-0 ...

Oracle Function returns ORA-06553: PLS-382: expression is of wrong type

I am getting the following error: ORA-06553: PLS-382: expression is of wrong typeand I cannot figure out why. Any help is surely appreciate. CREATE OR REPLACEFUNCTION Get_Is_Scheduled ( i_Key IN VARCHAR2,--ram_user_approvals.tran_key_value%TYPE,i_Category_ID IN VARCHAR2--ram_user_approvals.category_ ...

Oracle ora-06553: PLS:306

Can someone help me please. I am new to pl/sql.When I call this function in my sql, I keep getting ora-06553: PLS:306 wrong number or types of arguments in call to 'F_TEST' error. where I made error in my code?...sql:select DISTINCTpatnt.pasid,patnt.surname||' '||patnt.forename as name,sstay.start_d ...

Oracle getting ORA-06553: PLS-801: internal error [56319] on duplicate db.

I have used rman duplicate script to create a duplicate of our production db.The production db is running on linux itanium 64 bit and the server where the duplicate db is runninng on linux x86 32 bit. Both servers are running the smae rdbms version which is 9.2.0.7 On the duplicated db I get the fol ...

Oracle ORA-06553: PLS-306: 'XMLCONCAT' related error

Does anyone know what causes the error:ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLCONCAT'?The reason I ask is that I was told that it was an Oracle bug and to run - "drop public synonym xmlconcat;". This did take care of being able to use XMLCONCAT function, but wanted to ...

Oracle ORA-06553: PLS-213: package STANDARD not accessible

I have recently upgraded the database from 8.1.7.4 to 9.2.0.8 using dbua option. Recently when I was trying to execute few packages, I received the error:ORA-06554: package DBMS_STANDARD must be created before using PL/SQLWhen I run catalog.sql / catproc.sql, I get the error:ORA-06553: PLS-213: pack ...

Oracle Error message: ORA-06553: PLS-213: package STANDARD not accessible

I log in the database by owner 'sys'. and I tried to drop a user from the database. But the db didn't allow me to do this. Then, I want to copy the table structure from one schema to another schema. the error is come:ORA-06553: PLS-213: package STANDARD not accessibleUnreasonable that, I have tried ...

Oracle error w/ UPDATE in Stored Procedure - ORA-06553 PLS-306

I get the following error when executing my stored proc. from a Perl script: DBI ERROR: ORA-06553: PLS-306: wrong number or types of arguments in call to 'UPDATE_USER_PROJMGR' (DBD ERROR: OCIStmtExecute),QUERY: DBI::st=HASH(0x238cd4) Now, it's passing the correct number of values, the UPDATE stmt st ...

Oracle ORA-06553: PLS-907: cannot load library unit MDSYS.SDO-3GL

I used MapBuilder to create styles, themes and basemaps. When the first time I preview the basemap, it is ok.Then I zoom in the preview map, I got the following errors:ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: TOLL_HWYERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: ...

Oracle ORA-06553: PLS-801: internal error [hshuid:LU invalid]

DBA refreshed database B from database A (both 64-bit). Database C (also 64-bit) had a link to database B. DBA claims to have rebuilt the link from C to B, but queries now result in:SQL> select housing_pkg.f_housing_dep_amt@btest(12540, '200808', 'HEA');select housing_pkg.f_housing_dep_amt@btest( ...

Oracle ORA-06553: PLS-320: the declaration of the type of this expression

i getting this error "Error(62,17): PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed"i got this operationinsert into table_aselect * from table_bthis works finebut when i put the above code b ...

Oracle ORA-06553: PLS-221: 'SDO_GEOM' is not a procedure or is undefined

ORA-06553: PLS-221: 'SDO_GEOM' is not a procedure or is undefined06553. 00000 - "PLS-%s: %s"*Cause:*Action:...for...selectOBJECTID,GEOMfromSTATESwhereSDO_FILTER(GEOM,MDSYS.SDO_GEOM(2003,90112,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-179,-89.5166667,179,83.5166667)),'queryty ...

Oracle ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_Y'

select '1' as x from dual   select 1 as x from dual   select 'y' as x from dual these statements are running fine butwhen i am trying to run following select y as x from dual I am getting the following error why so?ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_Y' ...

Oracle ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

The following issues happen only on 10gR2, not on 10gR1.I've got a very simple schema registered and mapped to table "message". No data entered, jmust an empty table.SELECT extractValue(x.object_value, '/message/@uidMessage')FROM message x WHERE existsNode (x.object_value, '/message')=1causes "ORA-0 ...

Oracle ORA-06540 + ORA-06553: PLS-907: cannot load l

i have one procedure called by proc some time i used to get the following error;03/31/09 12:30 : 1398181 : colsys_cust_create procedure execution error -6540 ORA-06540: PL/SQL: compilation errorORA-06553: PLS-907: cannot load l what this means ? any inputs appreciated. ...

Oracle ORA-06553: PLS-908 when calling 10g remote procedure from 11g database

I have 2 instances: 11g (11.1.0.7) and 10g (10.2.0.4). When I try to call 10g (remote) procedure from 11g database, there is errors:ORA-04052: error occurred when looking up remote object CUSTOMER.PRL_PK2_GENERAL@CUSTOMER_LINKORA-06541: PL/SQL: compilation error - compilation abortedORA-06553: PLS-9 ...

Oracle ERROR: ORA-06553: PLS-801: internal error [55018]

Sorry for my bad english ...I got error ...ERROR: ORA-06553: PLS-801: internal error [55018] if I build function than return %rowtype like thisSELECT * INTO var_return FROM .......RETURN var_returnOracle 11g in RedHat Linux ...

Oracle ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU

I have installed Oracle fusion 11g on windows vista SP1 system. I have followed all the steps provided in the Oracle fusion installation guide.After installation when i tried to start the SOA server i'm continously getting the below warning message in the log file.[2009-11-27T03:18:23.203+05:30] [so ...

Oracle ORA-06553: PLS-801: internal error [56319]

i have opened my rman backup, not it works. (X64)but when i need to drop a user, i got error below, SQL> drop user ugur;drop user ugur*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-06553: PLS-801: internal error [56319]anybody got any idea, please? ...

Oracle ORA-06553 PLS-213

We are not experts. We are running Oracle 8i on Windows NT. and a have a medium sized database. While the database and the front end on the clients appear to be rumming alright we are unable to rum Oracle Enterprise manager. Moreover when we connect using SQL we receive the ORA-06553 PLS-213 Package ...

Oracle ora-06553: pls-707 error

There was 8.1.5 of oracle 8i installed. Later I removed 8.1.5 and installed8.1.7 on the same pc. I am using the same database which was created at the timeof installation of 8.1.5. Now when I am connecting to the database the followingerror message is appearing :ORA-06553: PLS-707 unsupported constr ...

Oracle ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

I'm having a similar problem to the one showed below :After executing SELECT *FROM dual xWHERE x.dummy IN (SELECT dummyFROM dual aWHERE a.dummy IN (SELECT d.dummyFROM (SELECT z.dummyFROM dual zWHERE x.dummy = z.dummy) d)); Error : ORA-06553: PLS-306: wrong number or types of arguments in call to 'OG ...

Oracle ORA-06553: PLS-307

R12DB 10.2.0.2We are unable to view, enter or update some information.Steps required to reproduce the problem 1. Open extra information type.2. go to standard " Iqama Details" EIT3.Below Error appearsAPP-FND-01564: ORACLE error 6553 in FDFGDFCause: FDFGDF failed due to ORA-06553: PLS-307: too many d ...

Oracle problems while exporting the database --- ORA-06553

I am getting the following error while exporting the database.In this regarding i would like to mention one thing Database server is of PL/SQL Release 9.2.0.5.0 - Production versions where as my Oracle client is of Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production version.Please find the lo ...

Oracle pls-553 when creating ctxsys.context index

People,I'm trying to create a context index on a clob column. Oracle returns a characterset name error (see below). I'm using AMERICAN_AMERICA.WE8ISO8859P1. Any ideas what I'm doing wrong? BTW this is the first context index I'm trying to create so if there are other things I might need to check, le ...

Oracle PLS-553: character set name is not recognized

I'm trying a complete restore of a full database backup and i'm getting the error:RMAN> restore database;Starting restore at 07-JAN-04using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ============ ...

Oracle Executing query caused ora-06553

SELECT PKG_SERVICE_REPAIRS_TIPS.FNC_PARTNO_FORMAT(PARTNO) FROM IMP_TEMP_PARTSLANGThe above query gives me the following errors. I think it's a problem with characterset, which I crosschecke at me level, if you can let me know, how should I trouble shoot the issue, I'll be greatfull to you. Error sta ...

Oracle ORA-06540 ORA-06553 PLS-00123

I'm having a problem with Oracle 9.0.1, I'm doing an export/import in my production database however I'm getting the errors 6540, 6553 an PLS-00123, it is sending the message that the program is too large, but it is not true, I did de import/export with the same parameters in another server (with th ...

Oracle please help ORA-06553: PLS-213: package STANDARD not accessible

i face this problem, and can not do any thing to DB,i can not do export/import,query....etc.please help me to solve this problem. ...

Oracle ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

No idea what OGC_X is.I have a SQL Query region with the source as: select x.PERSON_ID, x.ISSUE_ID, x.PERSON_ROLE from (SELECT apex_item.select_list_from_lov(1,person_id,'PEOPLE') PERSON_ID,apex_item.hidden(2,issue_id)|| apex_item.hidden(3,wwv_flow_item.md5(person_id,issue_id,person_role)) ck,apex_i ...

Oracle EXP-00008 + ORA-06544 + ORA-06553 + ORA-06508 error while exporting schema

i am exporting schema defnition from database;bash-2.05$ exp userid=pin/pin file=pin.dmp log=pin.log owner=pin rows=no i am getting this error:Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit ProductionWith the Partitioning optionJServer Release 8.1.7.0.0 - 64bit ProductionExport ...