Help dynamic query with DBMS_SQL package

From: Greg Gale <grgale_at_prince.env.gov.bc.ca_x>
Date: 16 Aug 99 14:32:40 PDT
Message-ID: <01bee82e$df6943b0$c0021b8e_at_grgalelgxp400>



[Quoted] Help Please!

I get an ORA-00911: invalid character from Oracle 7.3 with this statement: dbms_sql.parse(cursor_handle, 'select client_name from clients where client_name LIKE JON%', DBMS_SQL.V7);

but this one works just fine:
dbms_sql.parse(cursor_handle, 'select client_name from clients where client_name = JONES', DBMS_SQL.V7);

Thanks,

   -Greg- Received on Mon Aug 16 1999 - 23:32:40 CEST

Original text of this message