Re: Accessing variable table names in Forms 4.5

Hi,
With Pl/Sql in form
You must make
select into
from
Try this.
Claire
Brighton <someone_at_anywhere.com> a écrit dans l'article <742vua$ujf$1_at_newsreader1.core.theplanet.net>...
> Does anyone know how I could do the following in PL/SQL with Forms 4.5?
>
> select ename from tablename
>
> where tablename is a variable, that contains the name of a valid table?
>
> Whenever I try and do this, with for example select ename from :tbl_nme,
the
> PL/SQL compiler rejects this.
>
> I've tried the DBMS_SQL.EXECUTE(....) command but whenever I run this,
even
> from the SYS account, it says I have insufficient privelidges. Does
anyone
> know
> a simpler workaround?
>
> Many thanks
> mrittman_at_tmf-europe.com
>
>
>
>
>
Received on Wed Dec 02 1998 - 14:43:58 CET