I have a set of files that contain the SQL I need to create all
of the database objects I need. I currently open each file in Squirrel,
and run them. I want to have these run from maven. The problem I am
having is that the three procedures and one function I need all fail.
When loaded into Squirrel or SQL Developer - both that use the same JDBC
- the script runs just fine.
In looking at just the function, the failure is:
[INFO] Executing file:
/home/bv6679/Development/Schema/src/main/sql/C0003.sql
[ERROR] Failed to execute: i NUMBER
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] ORA-00900: invalid SQL statement
The contents are:
CREATE FUNCTION "AEQ_FN_COLLECT"( t IN AEQ_TYPE_VARCHAR2_TABLE )
RETURN CLOB
IS
collectFilters CLOB;
i NUMBER;
BEGIN
i := t.first;
WHILE i IS NOT NULL
LOOP
IF collectFilters IS NOT NULL THEN
collectFilters := collectFilters || ',';
END IF;
collectFilters := collectFilters || t(i);
i := t.next(i);
END LOOP;
RETURN collectFilters;
END; /
So I just can not figure out what is going on, and why it is not
working. Any ideas?
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
