In order to clean up the database I would like to first run a script
that creates a stored procedure that drops all tables, execute this
procedure and subsequently drop the procedure.
These are the first few lines of my create script:
CREATE OR REPLACE PROCEDURE DROP_USER_TABLES
IS
current_table_name VARCHAR2(32);
CURSOR table_cursor IS SELECT table_name FROM user_tables;
BEGIN
And this it the error I get:
[ERROR] Failed to execute: CURSOR table_cursor IS SELECT table_name
FROM user_tables;
Apparently the plugin is choking on the semicolon.
Can this be done somehow?
Kees
--
Cheers,
Kees de Kooter
http://www.boplicity.net
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
