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

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-00368: in RAISE statement, 'string' must be an exception name

1 2718

PLS-00369: no choices may appear with choice OTHERS in an exception handler

1 3282

PLS-00370: OTHERS handler must be last among the exception handlers of a block

1 3687

PLS-00371: at most one declaration for 'string' is permitted in the declaration section

4 29306

PLS-00372: In a procedure, RETURN statement cannot contain an expression

1 7793

PLS-00373: EXIT label 'string' must label a LOOP statement

1 3430

PLS-00374: illegal EXIT statement; it must appear inside the loop labeled 'string'

1 3309

PLS-00375: illegal GOTO statement; this GOTO cannot branch to label 'string'

1 5007

PLS-00376: illegal EXIT statement; it must appear inside a loop

1 4396

PLS-00377: internal type PLS_INTEGER is not included in this release of PL/SQL

1 2728

PLS-00378: invalid compilation unit for this release of PL/SQL

1 6211

PLS-00379: CASE statements are not included in this release of PL/SQL

1 2879

PLS-00380: functions and procedures are not included in this release of PL/SQL

1 2989

PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT

1 3220

PLS-00382: expression is of wrong type

1 4379

Un-Answered Questions { Database Errors }

When do you get "getwmicomexception"?

2735

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

8882

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

ORA-26032: index string.string loading aborted after string keys

2181

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2587

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

2786

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

6794

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.............

2867

ORA-26094: stream format error: input column overflow

2859

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2854

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?

2767

what is new g/l functionality

2677

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

3440

NZE-28868: Peer certificate chain check failed.

2868

IMP-00064: Definition of LOB was truncated by export

6473

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