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

ERRORS Interview Questions

Questions Answers Views Company eMail

ORA-06571: Function string does not guarantee not to update database

1 6348

ORA-06572: Function string has out arguments

1 6344

ORA-06573: Function string modifies package state, cannot be used here

1 3317

ORA-06574: Function string references package state, cannot execute remotely

1 3635

ORA-06575: Package or function string is in an invalid state

1 7178

ORA-06576: not a valid function or procedure name

1 7327

ORA-06577: output parameter not a bind variable

1 15444

ORA-06578: output parameter cannot be a duplicate bind

1 2850

ORA-06579: Bind variable not big enough to hold the output value

1 3654

ORA-06580: Hash Join ran out of memory while keeping large rows in memory

1 4339

ORA-06592: CASE not found while executing CASE statement

1 7075

ORA-06593: %s is not supported with natively compiled PL/SQL modules

1 3366

ORA-06600: LU6.2 Driver: SNA software is not loaded

1 2890

ORA-06601: LU6.2 Driver: Invalid database ID string

1 3119

ORA-06602: LU6.2 Driver: Error allocating context area

1 3142

Un-Answered Questions { ERRORS }

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

2656

ORA-16626: failed to enable specified object

2218

ORA-26095: unprocessed stream data exists

3573

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

3668

ORA-26027: unique index string.string partition string initially in unusable state

6746

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

2643

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

1681

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2731

hai i got one error i,e http status 404 error what is ds why ds is comming

2587

what is new g/l functionality

2612

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

2741

can u deactivate my music massage from mobily? some times i recharge my a/c then after sometimes one massage come and sr.4/- debited from my account. so please help me stop the massage about music or what. i don't know stop them please.from yesterday i have lose sr.8/- from my account.

2455

IMP-00064: Definition of LOB was truncated by export

6415

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

1747

I'm having trouble with coming up with the correct code. Thank You!! The assignment was to write a program using string functions that accepts a price of an item and displays its coded value. The base of the keys: X C O M P U T E R S 0 1 2 3 4 5 6 7 8 9 Sample I/O Dialogue: Enter Price: 489.50 Coded Value: PRS.UX

2162

For More Un-Answered { ERRORS } Questions Click Here