Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_sql problem
Yes - the error was in the SQL statement.
My apologies - I thought it was in the way I was using DBMS_SQL.
-- Noah Remove ".spam.begone" Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:orilntgsnkpmmhc71lh0heurhms58juuh5_at_4ax.com...Received on Thu Aug 16 2001 - 02:12:12 CDT
> On Wed, 15 Aug 2001 16:24:58 +0100, "Noah"
> <bowed_zombie_drone.spam.begone_at_zombie.co.uk> wrote:
>
> >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
>
>
> And without the statement the group can't either.
> Can't you just dbms_output the sqlstring and submit it to sql*plus.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>