I need to get some data from an external db and make some calculations with it in another db, is it possible to connect to an external db from a stored procedure? Thanks guys.
Im using Oracle and both databases are in the same server.
You want to use a Database Link (DBLink).
@conn_user on the end of a procedure or table name will tell the pl/sql engine to query the db link specified for that info.