Home » Developer & Programmer » Forms » how to connect all data base tables to oracle forms
how to connect all data base tables to oracle forms [message #287831] Thu, 13 December 2007 13:00 Go to next message
Messages: 2
Registered: December 2007
Junior Member

I have developed Oracle forms in 6i and our database client is
of version9i. Opearting system is windows XP.

I am able to compile the main menu but inside forms we are not
able to get all data base tables. when i am trying to add data base tables to forms by using data block wizard i am getting only default tables......!

Anyone plzzzz tell me how to get all tables including default tables..............!

thanks in advance..

Re: how to connect all data base tables to oracle forms [message #287845 is a reply to message #287831] Thu, 13 December 2007 15:04 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you call "default tables"?

In order to select table (or a view) as a data source, you must be connected to a database (specifying username, password and database alias). Objects you see belong to that schema.

What are the other tables you'd like to see? Those that belong to other users? If so, you'll have to grant required privileges and create synonyms in a schema that belongs to user who is developing forms.
Previous Topic: Error 305500 non-oracle exception with ole2 package and Outlook Application
Next Topic: batch file and PKZIPC utility
Goto Forum:

Current Time: Sat Aug 19 13:57:14 CDT 2017

Total time taken to generate the page: 0.05394 seconds