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-00993: Cursor Variables cannot be passed as RPC arguments or results

1 3310

PLS-00994: Cursor Variables cannot be declared as part of a package

CTS,

1 5236

PLS-00995: unhandled exception # string

1 3229

PLS-00996: out of memory

1 2725

PLS-00997: no cursor return types allowed in this beta version

1 2864

PLS-01400: Use of '||' token

1 3132

PLS-01401: Identifier over 18 characters long

1 2870

PLS-01402: Use of quoted identifier

1 2856

PLS-01403: Comment delimiters /* */

1 2796

PLS-01404: ANSI Identifiers can only consist of letters, digits, and the underscore character

1 3256

PLS-01405: Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

1 3007

PLS-01406: An identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's

1 2989

PLS-01407: One of the identifiers CHAR, CHARACTER, or INTEGER has been redefined by the programmer

1 2784

PLS-01408: Use of '&' token

1 3036

PLS-01409: Use of 'PRIOR_' token

1 3125

Un-Answered Questions { Database Errors }

hp asking for replication floppy to do reinstall 25254 server assistant

2969

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

2502

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

3916

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

IMP-00064: Definition of LOB was truncated by export

6473

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2948

When do you get "getwmicomexception"?

2735

ORA-26084: direct path context already finished

2001

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2804

How to view the error log for any specific instance?

2546

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

2260

write a database figure to implement the master detained relationship.

3020

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

3229

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

2590

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

2008

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