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

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-24365: error in character conversion

1 6133

ORA-24366: migratable user handle is set in service handle

1 3872

ORA-24367: user handle has not been set in service handle

1 3975

ORA-24368: OCI mutex counter non-zero when freeing a handle

1 3232

ORA-24369: required callbacks not registered for one or more bind handles

1 5435

ORA-24370: illegal piecewise operation attempted

1 3126

ORA-24371: data would not fit in current prefetch buffer

1 5052

ORA-24372: invalid object for describe

2 21074

ORA-24373: invalid length specified for statement

2 23269

ORA-24374: define not done before fetch or execute and fetch

2 14857

ORA-24375: Cannot use V6 syntax when talking to a V8 server

1 6847

ORA-24376: cannot register/get user callback for non-environment handle

1 3036

ORA-24377: invalid OCI function code

1 3927

ORA-24378: user callbacks not allowed for this call

1 3219

ORA-24379: invalid user callback type

1 3266

Un-Answered Questions { Database Errors }

What severity level errors are managed in TRY-CATCH block?

2269

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1736

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

4042

ORA-26094: stream format error: input column overflow

2859

ORA-16626: failed to enable specified object

2278

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

2868

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

8883

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

2008

When do you get "getwmicomexception"?

2735

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1710

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

1671

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

2789

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

3440

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2300

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

2237

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