Re: dbms_sql.parse fails my string

From: <esiyuri_at_my-dejanews.com>
Date: Thu, 02 Jul 1998 11:05:58 GMT
Message-ID: <6nfpim$7dm$1@nnrp1.dejanews.com>

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'');';

I hope that helps.
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 - 06:05:58 CDT