[
http://jira.codehaus.org/browse/MSQL-8?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dan Tran closed MSQL-8.
-----------------------
Resolution: Fixed
Fix Version/s: 1.1
please reopen if the block mode does not work out
> Execute a stored procedures from a script
> -----------------------------------------
>
> Key: MSQL-8
> URL: http://jira.codehaus.org/browse/MSQL-8
> Project: Maven 2.x SQL Plugin
> Issue Type: New Feature
> Reporter: Kees de Kooter
> Assignee: Dan Tran
> Fix For: 1.1
>
>
> 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:
> {noformat}
> CREATE OR REPLACE PROCEDURE DROP_USER_TABLES
> IS
> current_table_name VARCHAR2(32);
> CURSOR table_cursor IS SELECT table_name FROM user_tables;
> BEGIN
> {noformat}
> And this it the error I get:
> {noformat}
> [ERROR] Failed to execute: CURSOR table_cursor IS SELECT table_name
> FROM user_tables;
> {noformat}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
