Calling a Stored Procedure through OJB

[Anjishnu Bandyopadhyay <an...@infosys.com>]

Hi all,



I want to call an Oracle Stored Procedure (SP) through OJB (say, via the
PersistenceBroker object). Is there a way I can do it?



There is one way, as described in
http://db.apache.org/ojb/docu/howtos/howto-work-with-stored-procedures.h
tml.

But this does not serve my purpose. (The document talks of executing an
SP when a "persistable class/ bean" (corresponding to a row of data in a
table of database) is inserted/modified/deleted).



I intend to execute the procedure independent of any such bean
modifications. For example, I may trigger the SP if a particular
condition is met in my Java class.

I am looking for an alternative to the implementation of
"CallableStatement" Java API.



Please refer to the following code snippet:

CallableStatement stmt =  conn.prepareCall("call Upload_Data()");    //
"conn" is the object to connect to the database.

stmt.executeQuery();

I need an alternative to this.



Thanks for your time.



With best regards,

Anjishnu.





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***