Re: Execute immediate in forms6 not recognized?
From: bhogak <bhogak_at_attbi.com>
Date: Wed, 12 Jun 2002 01:29:32 GMT
Message-ID: <0txN8.16577$6m5.5371_at_rwcrnsc51.ops.asp.att.net>
Date: Wed, 12 Jun 2002 01:29:32 GMT
Message-ID: <0txN8.16577$6m5.5371_at_rwcrnsc51.ops.asp.att.net>
[Quoted] [Quoted] I am not sure if Forms6 supports 8i constructs. Forms has its own PL/SQL engine and it need not be the same as that of the database.
-- bhogak "ram" <rmurray_at_NRCan.gc.ca> wrote in message news:b05f8580.0206111052.6f434ee5_at_posting.google.com...Received on Wed Jun 12 2002 - 03:29:32 CEST
> I am trying a dynamic PL/SQL to get a single value from a table where
> the name of the table and the column to query are determined at
> runtime. If I try
>
> EXECUTE IMMEDIATE 'SELECT '||v_lookupf||' FROM '||v_lookup||' WHERE
> '||. . . etc.
>
> in any procedure or function (even by itself) I get
>
> Encountered the symbol IMMEDIATE when expecting one of the following
> . . .etc.
>
> Not understanding why this was happening I tried the old method of
> EXEC_SQL.OPEN_CURSOR etc. and got 4 errors, then DBMS_SQL.OPEN_CURSOR
> etc. and got 5 errors, so I think I try to fix the single error in
> execute immediate. Any suggestions?