desiboy1974
asked on
java stored procedures
Hi
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you exaplain exactly what you want to do? DO you want the java app to read a file and then connect to the Oracel db AND the PostGres Db?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here's quite a few samples on Oracle's technet site:
http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html
An article from Oracle Magazine (pay particular attention to the links at the bottom)
http://www.oracle.com/technology/oramag/oracle/03-jan/o13java.html
I've got to get to work. More later perhaps.
Regards,
Jim
http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html
An article from Oracle Magazine (pay particular attention to the links at the bottom)
http://www.oracle.com/technology/oramag/oracle/03-jan/o13java.html
I've got to get to work. More later perhaps.
Regards,
Jim
OK by me.
I'm happy...:-)
>>cs.execute();
prov.execute();