dbms_sql problem

Hello,

I'm trying to use some of the stuff in DBMS_SQL but am encountering problems.

My code is as follows:

v_cursor  INTEGER;
v_cursor_result  INTEGER;
v_sql  VARCHAR2(4000);

BEGIN   v_sql := <big SQL statement>;
  v_cursor := DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(v_cursor, v_sql, DBMS_SQL.NATIVE);   v_cursor_result := DBMS_SQL.EXECUTE(v_cursor);

The error I get is the following:

ORA-00933: SQL command not properly ended
ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "EASYGIS.MCHTEST", line 76
ORA-06512: at line 1

Line 76 is the "SQL_PARSE" line, but I can't see what I'm doing wrong. Any assistance'd be greatly appreciated.

Thanks

--
Noah
Remove ".spam.begone"