Re: Error with DBMS_SQL
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 20 Mar 2013 02:50:49 +0000 (UTC)
Message-ID: <kib869$rmj$6_at_solani.org>
On Tue, 19 Mar 2013 10:13:56 -0700, carlinodba wrote:
Date: Wed, 20 Mar 2013 02:50:49 +0000 (UTC)
Message-ID: <kib869$rmj$6_at_solani.org>
On Tue, 19 Mar 2013 10:13:56 -0700, carlinodba wrote:
> ERROR at line 1:
> ORA-00923: FROM keyword not found where expected ORA-06512: at
> "SYS.DBMS_SYS_SQL", line 909 ORA-06512: at "SYS.DBMS_SQL", line 39
> ORA-06512: at line 20
DBMS_SQL works. It's the SQL passed as an argument that doesn't work. Execute SQL separately in SQL*Developer. Don't use sqlplus, it's sooo 20th century.
-- http://mgogala.byethost5.comReceived on Wed Mar 20 2013 - 03:50:49 CET