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-02378: Invalid type for National Language character variable

1 2746

PCC-02379: Cannot equivalence National Language character variables

1 3346

PCC-02380: Cannot specify a connect mode when altering a user password

1 3113

PCC-02382: You must specify MODE=ANSI when using NLS_LOCAL=YES

1 3025

PCC-02383: Expecting an expression of type OCIExtProcContext

1 3077

PCC-02384: Missing array length specifier

1 2857

PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE

1 3572

PCC-02386: Use of the AT clause is not permitted here

1 2908

PCC-02387: Expecting an expression of type sql_cursor

1 3084

PCC-02388: Arrays not allowed in FROM/WHERE clause of SELECT statement

1 3459

PCC-02389: Arrays not allowed as input bind variables in SELECT list

1 3162

PCC-02390: No EXEC SQL CONTEXT USE statement encountered

1 3795

PCC-02391: Runtime context variable not of correct type

1 2963

PCC-02392: You are already in an EXEC SQL DECLARE SECTION

1 2845

PCC-02393: SQL statement found inside an EXEC SQL DECLARE SECTION

1 2715

Un-Answered Questions { Database Errors }

mount: mount to NFS server failed: System Error: Connection timed out

3665

What is Mutex error in Triggers?

3062

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

2593

NZE-28868: Peer certificate chain check failed.

2797

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3382

How to view the error log for any specific instance?

2480

NZE-28890: Entrust Login Failed

1873

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

IMP-00064: Definition of LOB was truncated by export

6411

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2637

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

2660

hp asking for replication floppy to do reinstall 25254 server assistant

2878

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

2443

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

1741

When do you get "getwmicomexception"?

2678

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