how to connect all data base tables to oracle forms [message #287831] |
Thu, 13 December 2007 13:00 |
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 |
|
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.
|
|
|