Re: database procedure compiling error

If you are compiling a procedure called 'test_proc' do this

alter procedure test_proc compile.

If oracle responds by issuing Warning! Procedure created with compilation errors, then type SHOW ERRORS on the SQL prompt. It will display all the errors.

Still, if you are using non sql*plus, then access DBA_ERRORS table to display all the errors for that procedure.

Sometimes, a procedure can be created with compilation errors but when you list the errors, it may say No errors. In that case, you need to re-run the procedure creation command and use show errors to list the errors

Hope it helps you

Regards

N.Prabhakar DBA
Socgen Crosby Securities,
Singapore

Tel : off 65 - 390 2228

      res 65 - 560 7785. Received on Sun Nov 03 1996 - 00:00:00 CET