Re: How to drop an nonexist table without the error message?

Here's your code corrected :

CREATE OR REPLACE FUNCTION Table_Exists (The_Table_Name IN VARCHAR2) RETURN BOOLEAN IS
  The_Table_Exists Boolean;
BEGIN

• Check if the table exists. SELECT True INTO The_Table_Exists WHERE EXISTS (SELECT Table_Name FROM User_Tables WHERE Table_Name = The_Table_Name);
• Return what we found. RETURN The_Table_Exists; END Table_Exists; /

(no need for declare, and don't use "as" to declare a variable)

CREATE OR REPLACE FUNCTION Drop_Table (The_Table_Name IN VARCHAR2) RETURN BOOLEAN IS
BEGIN

• Only drop a table if it doesn't exists. IF Table_Exists(The_Table_Name) THEN DROP TABLE Table_Name; end if ;
• If the table still exists, then something is wrong. IF Table_Exists(The_Table_Name) THEN RETURN FALSE; end if ;
• If we've come this far, then the table doesn't exists. RETURN TRUE; END Drop_Table;

("if" requires "end if")

Try this... Received on Tue May 09 2000 - 00:00:00 CDT