Re: Forms 4.5 Problem with Dynamic SQL.

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 8 May 1999 19:06:41 GMT
Message-ID: <7h2201$gpo$1_at_nntp.csufresno.edu>

I don't think it is the Forms_DDL. I use both Forms_DDL and DBMS_SQL in my QA Utility form, and all works fine. I'll bet if you code an insert or delete statement inside a Forms_DDL statement instead of your DBMS_SQL call, you will get the same 942 error message. As the other answer to your post says, it is probably something to do with roles and security.

Steve Cosner

---

http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table.

In article <3731c04f.0_at_news.mountain.net>, Kenny Gump <kgump_at_mylanlabs.com> wrote:
>I have an application which first starts a logon screen(a form developed
>with D2K), this screen allows the user to pick which part of the application
>they wish to use. It checks security and sets synonyms for the user using
>forms_ddl and then calls the Main Menu form. One of the forms called from
>the Main Menu form uses DBMS_SQL dynamic SQL. If I run this form after a
>forms_ddl statement has been issued it returns an error ORA-00942 table or
>view does not exist, but, if I run the form stand-alone it works fine. The
>users have access to the tables and it is not a synonym problem because the
>dynamic sql is using fully qualified names (i.e. schema.tablename) to avoid
>any conflict.
>
>I am using Forms 4.5 on Windows 95 but also ported to Sun Solaris and the
>same thing happens. Database is 7.3.2.3.
>
>Has anyone had a problem with forms_ddl or DBMS_SQL?
>
>Thanks in advance,
>
>Kenny Gump
Received on Sat May 08 1999 - 21:06:41 CEST