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-00212: could not obtain enough memory to compile CASE statement

1 2704

PLS-00213: package STANDARD not accessible

1 3639

PLS-00214: BEGIN...END block nesting is too deep

1 3365

PLS-00215: String length constraints must be in range (1 .. 32767)

2 8262

PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 7035

PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)

1 3308

PLS-00218: a variable declared NOT NULL must have an initialization assignment

1 5378

PLS-00219: label 'string' reference is out of scope

1 2970

PLS-00220: simple name required in this context

1 5954

PLS-00221: 'string' is not a procedure or is undefined

1 9368

PLS-00222: no function with name 'string' exists in this scope

QuinStreet,

1 15265

PLS-00223: paramaterless procedure 'string' used as function

1 3587

PLS-00224: object 'string' must be of type function or array to be used this way

1 10329

PLS-00225: subprogram or cursor 'string' reference is out of scope

1 5262

PLS-00226: package 'string' used as variable reference

1 3813

Un-Answered Questions { Database Errors }

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2582

What is live lock, deadlock and what is Lock escalation?

2502

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

1671

What is SCD (Slowly Changing Dimensions)? What are its types?

2721

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

8883

When do you get "getwmicomexception"?

2735

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

2269

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

NZE-28890: Entrust Login Failed

1932

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2523

IMP-00064: Definition of LOB was truncated by export

6473

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

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

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2258

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

2181

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