Oracle
1Z0-144 · Question #5
You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded. The procedure should return an "error" condition to…
The correct answer is C. The RAISE_APPLICATION_ERROR procedure. The procedure should return an error condition to the caller in a manner consistent with other Oracle server errors.
Configuring JDBC Data Sources
Question
You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded. The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors. Which construct should be used to handle this requirement?
Options
- AThe SQLERRM function
- BThe PRAGMA EXCEPTION_INIT function
- CThe RAISE_APPLICATION_ERROR procedure
- DA user-defined exception used with a raise statement
How the community answered
(37 responses)- A16% (6)
- B8% (3)
- C73% (27)
- D3% (1)
Explanation
The procedure should return an error condition to the caller in a manner consistent with other Oracle server errors.
Topics
#RAISE_APPLICATION_ERROR#user-defined exceptions#PL/SQL#error propagation
Community Discussion
No community discussion yet for this question.