Oracle Database Errors or Warnings from Error ORA-06554 to ORA-06560

SQLServerF1

 

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
Cause: The DBMS specific extensions to PL/SQL’s package “STANDARD” are in package “DBMS_STANDARD”. This package must be created before using PL/SQL.
Action: Create package “DBMS_STANDARD”. The source for this PL/SQL stored package is provided with the distribution.
ORA-06555: this name is currently reserved for use by user SYS
Cause: You tried to create a package named “STANDARD”, “DBMS_STANDARD” or “DEBUG_IO”. These are currently reserved for use by user SYS.
Action: Choose another name for your package.

ORA-06556: the pipe is empty, cannot fulfill the unpack_message request
Cause: There are no more items in the pipe.
Action: Check that the sender and receiver agree on the number and types of items placed on the pipe.
ORA-06557: null values are not allowed for any parameters to pipe icd’s
Cause: Internal error from the dbms_pipe package.
Action: None

ORA-06558: buffer in dbms_pipe package is full. No more items allowed
Cause: The pipe buffer size has been exceeded.
Action: None
ORA-06559: wrong datatype requested, string, actual datatype is string
Cause: The sender put different datatype on the pipe than that being requested (package ‘dbms_pipe’). The numbers are: 6 – number, 9 – char, 12 – date.
Action: Check that the sender and receiver agree on the number and types of items placed on the pipe.
ORA-06560: pos, string, is negative or larger than the buffer size, string
Cause: Internal error from the dbms_pipe package.
Action: None

Above are list of Oracle Database Errors or Warnings from Error ORA-06554 to ORA-06560 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *