ERRORS Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ERRORS Interview Questions

Questions Answers Views Company eMail

PCC-02378: Invalid type for National Language character variable

1 2830

PCC-02379: Cannot equivalence National Language character variables

1 3419

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

1 3222

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

1 3132

PCC-02383: Expecting an expression of type OCIExtProcContext

1 3171

PCC-02384: Missing array length specifier

1 2953

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

1 3654

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

1 3006

PCC-02387: Expecting an expression of type sql_cursor

1 3236

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

1 3587

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

1 3253

PCC-02390: No EXEC SQL CONTEXT USE statement encountered

1 3925

PCC-02391: Runtime context variable not of correct type

1 3041

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

1 2947

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

1 2850

Un-Answered Questions { ERRORS }

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

2678

why we are using shift key in unix shell script

3243

ORA-16626: failed to enable specified object

2282

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

2193

ORA-26084: direct path context already finished

2005

Answers for Complete This Song B_C_A_A _IL K_A KA_E, S__AN J__E B__D_ J__E

3276

how to overload main method in java?

3099

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

3234

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2792

What is the meaning of lock escalation and why/how to stop this?

2718

How to view the error log for any specific instance?

2548

Jetking is C C

2722

How to create a program that lists countries capitals when country is entered? (Terribly sorry, I'm a complete novist to coding with C, am looking for inspiration and general tips on how to code and create this program.)

1495

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

2726

What is the difference between return code and completion code. When i was searching in the direct for the problem, the following errors displayed. Please can any1 explain these. Completion Code => 4 Message Id => XXDR012I Short Text => XDR field overflow. Key=SER. Len=8. Completion Code => 8 Message Id => XSQF009I Short Text => Sys call open() failed.Filename=/opt/apps/cdt3/USA/outbound/CD810O.errno=17. Completion Code => 8 Message Id => XCPR010I Short Text => Open failed for copy in OPEN_DEST_DATA. Errno=17. can you explain those 3 completion codes and also with difference between return code and completion code

11948

For More Un-Answered { ERRORS } Questions Click Here