You're right on target - as soon as I removed the ';', it worked great.
Thanks to all for the helpful suggestions.
Cory
Matthias Gresz wrote:
>
> Hi,
>
> think the only fault you maid is, that your SQL-Statement(SQL_STMT) ends with a ';'.
>
> On Tue, 14 Apr 1998 15:20:56 -0400, Cory Brooks <coryb_at_lilly.com> wrote:
>
> >I am getting an invalid character error when I try to execute a stored
> >procedure containing a dbms_sql.parse command.
> >
> >If I hard code the "statement" (second parameter), it works ok.
> >Eg. dbms_sql.parse(cursor_#,'Select ...',DBMS_SQL.V7);
> >
> >
> >If I build the statement in a Varchar2 or Char variable
> >Eg.
> >SQL_STMT := 'Select ...';
> >DBMS_SQL.PARSE(CURSOR_NUM,SQL_STMT,DBMS_SQL.V7);
> >
> >fails with the following message:
> >*
> >ERROR at line 1:
> >ORA-20400: ORA-00911: invalid character
> >
> >Has anyone successfully used a character variable for the statement and
> >if so, was it necessary to do anything special?
> >TIA
> >Cory Brooks
>
> --
>
> Regards
>
> Matthias Gresz :-)
>
> GreMa_at_T-online.de
Received on Wed Apr 15 1998 - 12:05:32 CDT
