Drop IF EXISTS

[howzatUK]

CREATE OR REPLACE PROCEDURE DeleteIfExists
AS
iexists Number;
BEGIN
select count(*) into iexists from user_tables where table_name = 'tmpFIXDCActns';
if
iexists := 1
then execute immediate 'drop table tmpFIXDCActns';
end if;
END;

I was told that the in ORACLE you cannot use DROP IF EXISTS and writting the above code is a way around this.

However the above proc compiles with errors. Can anyone tell me why that is?

Thank you in advance

 

[sem]

1. You may make an attempt to drop and then catch an error instead.
2. Most names in Oracle are in uppercase.
3. := assigns, not compares.

Regards, Dima

http://seminihin.narod.ru

 

[howzatUK]

thank you. Ofcourse!!!! the problem was number 3) :=

Thanks