PLS-00584: size of an opaque type must be between 1 and 4000
bytes



PLS-00584: size of an opaque type must be between 1 and 4000 bytes..

Answer / guest

Cause: An attempt was made to specify an explicit size for
an opaque type, but the specified size was out of the valid
range.

Action: Change the explicit size to be between 1 and 4000
bytes, or change the declaration to be varying-length
without an explicit size.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00547: user information retrieval failed

1 Answers  


ORA-38459: XML Tag "string" not found for the XMLType attribute "string"

1 Answers  


PCC-02396: Illegal use of arrays inside an array of structs

1 Answers  


PCB-00009: Cannot change MAXLITERAL after an EXEC SQL statement

1 Answers  


ORA-13526: baseline (string) does not exist

1 Answers  


ORA-26665: STREAMS process string already exists

1 Answers  


I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed

2 Answers  


TNS-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


ORA-10579: Can not modify control file during test recovery

1 Answers  


RMAN-06204: Changed string objects to UNAVAILABLE status

1 Answers  


ORA-29846: cannot create a local domain index on a string partitioned table

1 Answers  


Categories