Re: dbms_sql problem

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 Received on Wed Aug 15 2001 - 14:21:38 CDT