Small fix :) You can have for example specified "/" as delimiter string and "row" as delimiter type.
-----Original Message----- From: Artamonov, Juri [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 11:38 AM To: [email protected] Subject: RE: [mojo-user] [sql plugin] How can I execute a stored procedure? 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 --------------------------------------------------------------------- To unsubscribe from this list please visit: http://xircles.codehaus.org/manage_email
