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
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
