Re: Query same object(s) on different SID using Forms4.5

KrishnaKumar Ramanathan wrote:
>
> This is the scenario..
>
> I have say 10 databases split across different machines.
> I want to query for eg:DBA_OBJECTS on these different databases from
> a a single form(using 4.5). I can provide a drop list for the address of
> these machines and their corresponding SID's. The username and password
> will also be entered before connecting. Now what r the simplest ways of
> connecting and performing the query?
>
> Eg: Address:T:121.213.23.1 SID:ABC Username:HELLO Passwd:XXXX
>
> -----DBA_OBJECTS--------------------------------------------------------Owner ObjectName ObjectType
> ------------------------------------------------------------------------SYSTEM XXXXXX TABLE
> USERS1 YYYYYY VIEW
> ... ... ....
>
> Please let me know ur ideas/comments.
>
> Thanks in advance..
>
> Mohan
> ou90066_at_deere.com

Hi,

From the application point of view I can thinkof two options 1. If you need to query one DB at a time, you can use the LOGON builtin

   to change your DB connection.
2. If you need to access all the DBs at the same time, use OPEN_FORM

   builtin, making different LOGON in each opened form.

Good luck

        Hadar Paiss Received on Wed May 29 1996 - 00:00:00 CEST