Oracle Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Errors Interview Questions

Questions Answers Views Company eMail

PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 3257

PCC-00061: Error at line number, column number. PLS-number: string

1 3010

PCC-00062: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 5590

PCC-00063: Reached end of file string before End-of-Statement at line number!

1 3673

PCC-00064: All uses of a given host variable must use identical indicator variables.

1 2783

PCC-00065: Userid required, but not specified.

1 2950

PCC-00066: Userid only used when SQLCHECK = FULL, userid ignored.

1 3281

PCC-00067: Ireclen exceeded. Line number in file string truncated.

1 3340

PCC-00068: Host and indicator variables may not have the same name.

1 2703

PCC-00069: Host variable "string" has unsupported datatype at line number in file string

1 3424

PCC-00070: Illegal syntax, Exponential value in SQL statement: string

1 3556

PCC-00071: Unable to open message file.

1 2881

PCC-00072: Input file name length exceeds the maximum length

1 3043

PCC-00073: Cursor is declared but never OPENed at line number in file string.

1 2716

PCC-00075: ":" expected before indicator variable

1 3125

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26079: file "string" is not part of table string.string

1958

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

ORA-26076: cannot set or reset value after direct path structure is allocated

1965

RMAN-05017: no copy of datafile number found to recover

2410

ORA-16626: failed to enable specified object

2216

ORA-26084: direct path context already finished

1949

ORA-16516: The current state is invalid for the attempted operation.

8816

IMP-00070: Lob definitions in dump file are inconsistent with database.

1743

IMG-02003: 2FF03 - incorrect color histogram feature specification

1706

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1616

ORA-26027: unique index string.string partition string initially in unusable state

6744

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3383

ORA-16627: No standby databases support the overall protection mode.

3987

ORA-26030: index string.string had string partitions made unusable due to:

1941

NZE-28868: Peer certificate chain check failed.

2799

For More Un-Answered { Oracle Errors } Questions Click Here