Some times Sql plus does not show any error by “Show Error” command however if you compile a pl/sql code it shows Compilation Warnings.
For that there is another way to see all errors occured in compiling pl/sql code of any database object from any oracle Client e.g Sql plus,Toad,Pl/sql Developer etc.You can see all error using following query
select text from dba_errors where name = ‘[OBJECT_NAME]‘ and owner = ‘[OBJECT_OWNER]‘;
Where [OBJECT_NAME] is then name of Database object which is created by this code
[OBJECT_OWNER] is the name of schema in which you are trying to create object.
Hope it will help…
Advertisement
