call stored procedure from java
Posted on 2003-12-11
I am new to working with java against the DB.
The DBA wrote the following stored procedure:
config_pkg.get_app_config_xml(i_app_name => :i_app_name,
o_xml => :o_xml);
i_app_name defined as String
o_xml defined as Cursor
and I want to write a simple java code which run this procedure.
The procedure should get A string and return XML.
Assume I have already a connection to the db how will be the rest of code:
public static void main(String args)
Connection conn = getConnection(...);
//WHAT SHOULD I DO HERE