You can have for example specified "/" string as delimiter type and
"row" as delimiter type.
Having these settings will allow to read the following procedure as
single unit and apply it.
CREATE OR REPLACE PROCEDURE DROP_USER_TABLES
IS
current_table_name VARCHAR2(32);
CURSOR table_cursor IS SELECT table_name FROM user_tables;
BEGIN
Some sql
END
/
Best regards,
Juri.
-----Original Message-----
From: Kees de Kooter [mailto:[EMAIL PROTECTED]
Sent: Monday, November 26, 2007 11:22 AM
To: [email protected]
Subject: [mojo-user] [sql plugin] How can I execute a stored procedure?
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
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
