How to access the underlying Postgre for a Stored procedure

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc

Poston Mon, 29 May 2006 4:37 pm

I would like to know if anyone knows a way to get data into an underlying postgre Sql for Oracle database?

from the forms I got access, but would like to directly access the Oracle Database.
Location: Campo Grande - MS

Thiago Bourscheidt
Analista de Sistemas

Poston Mon, 05 Jun 2006 12:56 pm

I never made that connection, but there is a thing called HS-Heterogeneous Services which aims exactly to connect oracle in several different banks.
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Poston Mon, 05 Jun 2006 11:06 pm

Lavellec, you can write stored procedures in java by accessing the postgres, and making queries in java etc, and what do you need more, you can montrar another stored procedure, pack, etc, for you to work with your normal base. I.e. a pack for you to work with your data, and another pack (procedure, etc.) in java to connect and make queries in postgre save in eventual partnership tables etc. ..
Or you can use the também Oracle Gateway, but I don't know much about this:P flow uncle ...
t + plus ...
Location: Toledo - PR

  • See also
    Last Post