[
http://jira.codehaus.org/browse/MSQL-8?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_119022
]
kdekooter edited comment on MSQL-8 at 1/7/08 7:39 AM:
-----------------------------------------------------------
Still not working for me.
Here is the script I need to execute. It runs fine from the Oracle GUI tools.
However if I run it with blockmode enabled it is executed as one statement.
{noformat}
CREATE OR REPLACE PROCEDURE DROP_USER_TABLES
IS
(.....)
END;
/
CREATE OR REPLACE PROCEDURE DROP_USER_SEQUENCES
IS
(.....)
END;
/
EXECUTE DROP_USER_TABLES;
/
EXECUTE DROP_USER_SEQUENCES;
/
DROP PROCEDURE DROP_USER_TABLES;
/
DROP PROCEDURE DROP_USER_SEQUENCES;
/
{noformat}
was (Author: kdekooter):
Still not working for me. Here is the script I need to execute.
It runs fine from the Oracle GUI tools:
{noformat}
CREATE OR REPLACE PROCEDURE DROP_USER_TABLES
IS
(.....)
END;
/
CREATE OR REPLACE PROCEDURE DROP_USER_SEQUENCES
IS
(.....)
END;
/
EXECUTE DROP_USER_TABLES;
/
EXECUTE DROP_USER_SEQUENCES;
/
DROP PROCEDURE DROP_USER_TABLES;
/
DROP PROCEDURE DROP_USER_SEQUENCES;
/
{noformat}
> 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
>
> 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
