Need to be able to check if a Stored procedure already exists.
I am familiar with SQL Server code as in
Begin
If Exists (select name from sysObjects where
name = 'procName' and type = 'P)
Drop procedure 'procName'
End
Can I replicate that in concept Oracle.
I don't plan to replace the proc so "Create or Replace" will not work.
Thanks in advance.
I am familiar with SQL Server code as in
Begin
If Exists (select name from sysObjects where
name = 'procName' and type = 'P)
Drop procedure 'procName'
End
Can I replicate that in concept Oracle.
I don't plan to replace the proc so "Create or Replace" will not work.
Thanks in advance.