Coonect to another server in stored procedure?

[mahoori]

Hi all.
Can I connect to another oracle server in one stored procedure?
Is it possible?
If possible,What is syntax?
connect? logon?
Best regards.

[vinit]

first create a db link from where you want to access data in your stored procedure.
Once the db link is created you can use your stored procedures to access data from the other database using the @dblink clause.

[vinit]

Sorry, the reply posted earlier is just a work around but i hope that is what you are intending to do. I do doubt if you can connect using the connect command.

[mahoori]

Hello vinit.
Thank you very much for reply.
I need connection to any DB server(Oracle,DB2,ODBC,...) in my stored procedure. db link can not do this operation.
What is syntax for connection?
I am waiting for reply.
Cheers.

[ngwh]

why do u need a connect from within a procedure to another server?
..so depends on ur purpose perhaps we can help?

[BIGDELI]

Hello ngwh
we have some rows in oracle and need to insert into a supra dabase . we make a cursor and change connection and insert
into supra . it's ok ?

[mahoori]

Hi friends.
This thread will be continued by Mr. Bigdeli.
He is my colleague.
Best Regards.

[pando]

i doubt it you can connect to a supra database from oracle without some kind of gateway