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-00627: 'string' must be a strongly typed ref cursor

1 3847

PLS-00628: 'string' must be a valid record attribute

1 2840

PLS-00629: PIPE statement cannot be used in non-pipelined functions

1 10235

PLS-00630: pipelined functions must have a supported collection return type

2 13743

PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument

1 2849

PLS-00632: NOT INSTANTIABLE method cannot have a body

1 2991

PLS-00633: RETURN statement in a pipelined function cannot contain an expression

1 5866

PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE

1 4526

PLS-00635: method does not override

1 4785

PLS-00636: overriding method requires OVERRIDING keyword

1 3793

PLS-00637: FINAL method cannot be overriden or hidden

1 2769

PLS-00638: cannot overload MAP method

1 2792

PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

1 3468

PLS-00640: a pipelined function cannot be called from PL/SQL context

1 2827

PLS-00641: INTO clause not allowed for this SELECT statement

1 2811

Un-Answered Questions { Database Errors }

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6651

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

2155

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

2410

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

2230

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

2105

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2801

what is the instrument that used in Mechanical Energy??

2680

When do you get "getwmicomexception"?

2680

How to view the error log for any specific instance?

2486

What is the use of NOLOCK locking hint?

1784

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

3155

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

1616

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

1677

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

3862

NZE-28868: Peer certificate chain check failed.

2799

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