Oracle Apps Interview Questions

37 oracle apps interview questions shared by candidates

PL/SQL - Let's say we have a PL/SQL block in which we have 2 Exceptions. 1) WHEN NO_DATA_FOUND THEN 2) WHEN OTHERS THEN. In the Exception part of the block, the exception - WHEN OTHERS THEN is written before WHEN NO_DATA_FOUND Exception. Then what kind of error do you get? Will the code work? (Hint - Compilation Error)
avatar

Oracle Apps Technical Consultant

Interviewed at Oasis TechnoSoft

4.4
Apr 17, 2025

PL/SQL - Let's say we have a PL/SQL block in which we have 2 Exceptions. 1) WHEN NO_DATA_FOUND THEN 2) WHEN OTHERS THEN. In the Exception part of the block, the exception - WHEN OTHERS THEN is written before WHEN NO_DATA_FOUND Exception. Then what kind of error do you get? Will the code work? (Hint - Compilation Error)

Viewing 1 - 10 interview questions

Glassdoor has 37 interview questions and reports from Oracle apps interviews. Prepare for your interview. Get hired. Love your job.