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

Oracle Errors Interview Questions

Questions Answers Views Company eMail

PLS-00490: illegal statement

1 3139

PLS-00491: numeric literal required

1 3588

PLS-00492: variable or constant initialization may not refer to functions declared in the same package

1 3104

PLS-00493: invalid reference to a server-side object or function in a local context

1 3979

PLS-00494: coercion into multiple record targets not supported

1 4708

PLS-00495: too many columns in SELECT...INTO statement after bursting record targets

1 2904

PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

1 3201

PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

1 18364

PLS-00498: illegal use of a type before its declaration

1 5319

PLS-00499: coercion into collection of records not supported

1 2796

PLS-00500: invalid operator binding

1 3238

PLS-00503: RETURN statement required for this return from function

1 4726

PLS-00504: type string_BASE may not be used outside of package STANDARD

1 2976

PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

1 3692

PLS-00506: User Defined Constrained Subtypes are disallowed

1 2990

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26028: index string.string initially in unusable state

3916

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

4042

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2761

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2769

NZE-28890: Entrust Login Failed

1932

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

1801

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

1769

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

2471

NZE-28868: Peer certificate chain check failed.

2868

ORA-16626: failed to enable specified object

2278

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2789

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

2008

ORA-26094: stream format error: input column overflow

2859

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

3440

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.

2948

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