java stored procedures
Posted on 2005-03-22
I need some feed back on how to use jave stored procedres..
basically i've written a pl/sql procedure that uses utl file functions to load a csv file into a oracle database. A sheel scipt is used to call the plsql procedure that loads it from a particular directory. all this works fine.
I need the stored procedure to do the following..as it parses each record in the file and loads it inot the oracle database, i need it to connect to a postgres database and do an updtate...i have the jar files to connect to a postgres database..i've heard this can be accomplished using java stored procedures ..so basically have the plsql stuff and the postgres stuff within the java stored poc and call the java stored proc from the shell script.
..can anyone help me here?..an example would be good