It would help if you included the actual
value of v_sql as that is probably where
the problem lies. I could take a guess
that you have included a ';' as the last
character of the sql text.
--
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
Noah wrote in message ...
>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"
>
>
Received on Wed Aug 15 2001 - 10:30:24 CDT
