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
chaitu.junnu
Messages: 2
Registered: December 2007
Junior Member
Hi,

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
Littlefoot
Messages: 21823
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: Problem reading DATEs from Excel via OLE2
Next Topic: How to make one vertical Tool bar for all forms
Goto Forum:
  


Current Time: Sat Dec 14 16:41:23 CST 2024