running dynamic pl/sql in forms

I am upgrading from Forms 4.5 in character mode to Forms 6.0 in character mode. As Forms 6.0 doensn't support full screen menus, I need to replace the menus with a form that has the same functionality. I have used the documentation feature of Forms 6.0 to get a text file that has all the menu items and their properties in. I have then parsed this with a C program I wrote to get 2 CSV files, one with an entry for each menu item and its properties and pl/sql code and another with a line for each menu, item and database role for the security.

I have loaded these files into a couple of tables and wish to write a form based on them that mimics the old full screen menu functionality.

My only problem is that I can't seem to find a way to fetch the Pl/SQL code from the table and run it from the form, in effect doing dynamic PL/SQL.

Does anybody know of a way round this?

Adrian Keeling Received on Thu Jun 14 2001 - 17:25:09 CEST