Dobry vecer,
ano, je to mozne. Pri pouziti Oracle JDBC drivera mate k dispozicii
OracleTypes, ktore obsahuju aj typy ako BLOB a CLOB.
Mohlo by to vyzerat nejako takto:
/*
ziskanie conn (zvycajne z poolu)
*/
CallableStatement cs = conn.prepareCall("{call
PACKAGE.Get_CLOB_File(:p_something_in, :p_clob_cont, :p_ret_code_OUT)}");
cs.setString("p_something_in", "CLOB_ID"); // len priklad
parametra, napr. na zaklade ktoreho sa vrati nejaky specificky CLOB
cs.registerOutParameter("p_clob_cont", OracleTypes.CLOB);
cs.registerOutParameter("p_ret_code_OUT", OracleTypes.INTEGER);
cs.execute();
Clob clobContent = cs.getClob("p_clob_cont");
/*
ziskanie obsahu CLOBU - standardne java.sql.Clob metody
clobContent.
InputStream is = clobContent.getAsciiStream();
Reader r1 = clobContent.getCharacterStream();
Reader r2 clobContent.getCharacterStream(pos, length);
String s = clobContent.getSubString(pos, length);
*/
int retCode = cs.getInt("p_ret_code_OUT");
System.out.println("Result: " + retCode);
Pisem to z hlavy rovno do mailu, takze za to nerucim na 100% :-)
S pozdravom,
Juraj
On 02/28/2011 06:54 PM, Ivan Polak wrote:
Zdravim konferenciu,
Potreboval by z javy zavolat oracle plsql funkciu,ktora by vratila
clob.je <http://clob.je> to mozne?nepodarilo sa mi nic pouzitelne
vygooglit.
Dakujem
Ivan
