Oracle Apps Technical Interview Questions

45 oracle apps technical 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
17 Apr 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 45 interview questions and reports from Oracle apps technical interviews. Prepare for your interview. Get hired. Love your job.