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-00242: invalid external type specification for CONTEXT

1 3075

PLS-00243: invalid external type specification for SQLNAME

1 2913

PLS-00244: Multiple declarations in foreign function formal parameter list

1 3686

PLS-00245: Formals used in the 'parameters' clause must appear exactly once

1 3101

PLS-00246: PARAMETER STYLE is unsupported

1 4255

PLS-00247: LIBRARY name must be specified

1 3422

PLS-00248: Invalid Library Syntax

1 3811

PLS-00249: Invalid WITH CONTEXT Syntax

1 3292

PLS-00250: Incorrect Usage of string in parameters clause.

1 2949

PLS-00251: RETURN, for actual function return, must be last in the parameters clause

1 3211

PLS-00252: reference to the wrong copy of package STANDARD

1 4095

PLS-00253: Formal parameter string missing in the parameters clause

1 3771

PLS-00254: OUT and IN/OUT modes cannot be used in this context

1 3582

PLS-00255: CALL Specification parameters cannot have default values

1 4966

PLS-00256: %s is not a valid external library

1 3244

Un-Answered Questions { Database Errors }

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

2236

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

2300

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

2006

What is the use of NOLOCK locking hint?

1837

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

1801

what is the instrument that used in Mechanical Energy??

2740

why we are using shift key in unix shell script

3237

IMP-00064: Definition of LOB was truncated by export

6473

When do you get "getwmicomexception"?

2735

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

3229

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-26028: index string.string initially in unusable state

3916

ORA-26084: direct path context already finished

2000

NZE-28868: Peer certificate chain check failed.

2868

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

2760

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