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

Database Errors Interview Questions

Questions Answers Views Company eMail

PCC-02394: Input file name and output filename are identical

1 2831

PCC-02395: Using arrays of structs requires that the struct be named

1 4528

PCC-02396: Illegal use of arrays inside an array of structs

1 2882

PCC-02397: VARCHAR declarations not permitted in #include file

1 5030

PCC-02398: Indicator ignored in this statement for this type

1 2812

PCC-02399: Illegal CHAR_MAP option value for DBMS=V6. Option ignored.

1 2823

PCC-02400: This host variable must be declared as a pointer type

1 3148

PCC-02401: Host variable arrays of this type are currently not supported

1 2755

PCC-02402: Pro*C option OBJECTS=YES is required when using the object cache

1 3166

PCC-02403: Invalid indicator variable type for this host variable

1 2826

PCC-02404: This indicator variable must be declared as a pointer type

1 3209

PCC-02405: Variable is of undefined type

1 3141

PCC-02406: Expecting the form 'RETURN[ING] REF INTO :' only

1 3576

PCC-02407: Object and REF types do not match

1 2928

PCC-02408: Expecting an expression of some Object type

1 3084

Un-Answered Questions { Database Errors }

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

1675

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

2520

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

1704

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

3151

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

2410

ORA-26082: load of overlapping segments on table string.string is not allowed

1767

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.

2797

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

1956

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

3859

ORA-26084: direct path context already finished

1947

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

1741

What is the meaning of lock escalation and why/how to stop this?

2647

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

2225

When do you get "getwmicomexception"?

2678

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

2221

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