Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBC CallableStatement to return boolean?

Stanley Lee-OracleJul 1 2009 — edited Jul 1 2009
Hi,

I would like to use JDBC to call a PL/SQL function and it returns a boolean type. However I do not see JDBC support it. Is there a way to do that? Thanks.

CallableStatement cs = conn.prepareCall ("begin ? := function(?); end;");
cs.registerOutParameter(1,Types.CHAR);
cs.setString(2, "aa");
cs.executeUpdate();
String result = cs.getString(1);

Comments

843807 
tree.addTreeSelectionListener(new javax.swing.event.TreeSelectionListener() {
            public void valueChanged(TreeSelectionEvent e) {
                // do whatever you want with table in here            
}
        });
Tonny
http://www.kiyut.com
(swing component)
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 29 2009
Added on Jul 1 2009
1 comment
558 views