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-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 3155

PLS-00171: duplicate dedicated AGENT specification in subprogram expression

1 2744

PLS-00172: string literal too long

1 8902

PLS-00173: SPACE, TAB or RETURN are disallowed as alternative quote delimiters

1 3830

PLS-00201: identifier 'string' must be declared

1 4180

PLS-00202: type 'string' must be declared

1 3052

PLS-00203: function DECODE must be called with at least 3 non-boolean arguments

1 3332

PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only

1 6034

PLS-00205: Aggregate not allowed here

1 2944

PLS-00206: %%TYPE must be applied to a variable, column, field or attribute, not to "string"

1 5775

PLS-00207: identifier 'string', applied to implicit cursor SQL, is not a legal cursor attribute

2 5148

PLS-00208: identifier 'string' is not a legal cursor attribute

1 6406

PLS-00209: table 'string' is not in FROM clause

1 2839

PLS-00210: an OTHERS clause is required in this CASE statement

1 3202

PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

1 2827

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26029: index string.string partition string initially in unusable state

2155

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

2731

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

1616

ORA-26094: stream format error: input column overflow

2797

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

1965

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3154

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

2696

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2800

NZE-28868: Peer certificate chain check failed.

2799

ORA-26084: direct path context already finished

1949

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

8816

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

1941

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

1743

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

3383

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

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