Re: Execute immediate in forms6 not recognized?

bhogak wrote:

> 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...
> > 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?

On the other hand there is a very easy workaround.

CREATE OR REPLACE PROCEDURE run_nds (param_in VARCHAR2) IS

BEGIN
   EXECUTE IMMEDIATE param_in;
END; And just call the procedure from the form.

Daniel Morgan Received on Wed Jun 12 2002 - 17:16:03 CEST