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

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-24808: streaming of lob data is not allowed when using lob buffering

1 3018

ORA-24809: amount specified will not fit in the lob buffers

1 3192

ORA-24810: attempting to write more data than indicated

1 3469

ORA-24811: less data provided for writing than indicated

1 5815

ORA-24812: character set conversion to or from UCS2 failed

1 11034

ORA-24813: cannot send or receive an unsupported LOB

1 5779

ORA-24814: operation not allowed for temporary LOBs

1 3249

ORA-24815: Invalid character set form

1 3253

ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

1 6370

ORA-24850: failed to startup shared subsystem

1 3200

ORA-24851: failed to connect to shared subsystem

1 3287

ORA-24852: protocol error during statement execution

1 4438

ORA-24853: failed to connect thread to shared subsystem

1 2987

ORA-24900: invalid or unsupported mode paramater passed in call

1 3580

ORA-24901: handles belonging to different environments passed into an OCI call

1 2870

Un-Answered Questions { Database Errors }

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6650

ORA-26094: stream format error: input column overflow

2798

ORA-16627: No standby databases support the overall protection mode.

3989

What is Mutex error in Triggers?

3064

What is the use of NOLOCK locking hint?

1784

why we are using shift key in unix shell script

3165

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.

2532

ORA-16626: failed to enable specified object

2218

what is new g/l functionality

2611

ORA-26082: load of overlapping segments on table string.string is not allowed

1768

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

2223

ORA-26095: unprocessed stream data exists

3561

hp asking for replication floppy to do reinstall 25254 server assistant

2880

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

2731

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

2595

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