Re: dbms_sql.parse fails my string

In article <6nfpim$7dm$1_at_nnrp1.dejanews.com>,   esiyuri_at_my-dejanews.com wrote:
>
> In article <6nenq7$sjv$1_at_nnrp1.dejanews.com>,
> 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.
> >
>
> You need to remove the trailing ";" within the statement. ie:
> stmnt := 'select table_name from dba_tables where owner = (''STARGATE'');';
>

Oops... I hit "send" before I finished... the correct statement should read:

stmnt := 'select table_name from dba_tables where owner = (''STARGATE'')';

(ie no ";" within the stmnt string).

Regards
Yuri McPhedran

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 08:21:10 CDT