Re: dbms_sql.parse fails my string

From: Paul Yee <yobble_at_ihug.co.nz>
Date: Thu, 2 Jul 1998 19:27:34 +1200
Message-ID: <1dbk0jt.1d7d4ol2ml9ogN@p52-max4.wlg.ihug.co.nz>

<aaronurbain_at_bigfoot.com> wrote:

> stmnt := 'select table_name from dba_tables where owner = (''STARGATE'');';
> cur := dbms_sql.open_cursor;
> dbms_sql.parse(cur, stmnt, dbms_sql.v7);
>
>
> If I remove the where clause, she works.
> if I put_line the stmnt, and paste it to a sql prompt, she works.
> it seems that the '' causes the parser a problem.
>
> who sees the problem?
> not me.
> -Aaron

Take off the brackets or use IN instead of =.

Paul Received on Thu Jul 02 1998 - 02:27:34 CDT