Re: Pro*c communication to database across machines

>This is very easy to do. All you need is a USING clause on the connect
>statement, with a valid SQL*Net string. For example:
>
>EXEC SQL CONNECT :username IDENTIFIED BY :password USING :sqlnet_string;

Alternately,

EXEC SQL CONNECT :username_at_service IDENTIFIED BY :password;

where service is the SQL*Net listener service name previously defined.

also, the same functionality may be obtained by creating synonyms for the local user that point to schema objects on the desired remote server.

-- 


>-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->

|                                                  |
|    Chris Kirke - cakirke_at_metroux.metrobbs.com    |  
|                                                  |
|    the opinions expressed here ..... whatever    |
|                                                  |
<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<