[
http://jira.codehaus.org/browse/MOJO-952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dan Tran closed MOJO-952.
-------------------------
Assignee: Dan Tran
Resolution: Fixed
please enableBlockMode configuration for detail. You will need to build the
site your self or see the source for instruction
> Execute a stored procedures from a script
> -----------------------------------------
>
> Key: MOJO-952
> URL: http://jira.codehaus.org/browse/MOJO-952
> Project: Mojo
> Issue Type: New Feature
> Components: sql
> Reporter: Kees de Kooter
> Assignee: Dan Tran
>
> 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
