From a predefined Session event, in the siebel application, trigger a call to the Oracle database and execute a package/procedure/function call and return a result back to the Siebel Session?
...
http://www.experts-exchange.com/Database/Siebel/Q_23386422.html