Your hint doesn't have a space between the /*+ and the hint as in /*+ RULE
*/. When there's a syntax error in a hint, the hint is simply ignored (no
error returned). I assume you're using cost-based optimization and you wish
to turn it off temporarily?
The other thing you ought to consider is wrapping each SQL/DML in a block
with its own exception handler. This way an exception can be handled
inline. Otherwise, the procedure's exception handler is invoked. Is that
really what you want? Now that I check, your procedure doesn't even have an
exception handler!! Bad design!! Always code an exception block and handle
the error there in some way so you can trap/detect it. Then raise it again
if you want the exception passed up to the calling context.
- djc
Received on Wed Oct 22 1997 - 00:00:00 CDT
