[ND] Oracle Stored Procedure returns data source execute exception

[bola taylor]

I have a problem in calling a particular stored procedure

I created a datasource that is used by five different stored procedures.
four of these stored procedures work properly but the fifth one does not work
I now tried th fifth stored procedure in SQL Plus with the same parameter list and 
it worked. The netd enviroment returns the following error

ecurityModule.priv_sprCancelTransaction.triggerDatabaseErrorEvent: execution of the 
DataObject 'priv_sprCancelTransaction' has failed:
                        securityModule.priv_sprCancelTransaction. System error code is 
28 (Data source execute exception)
                                   securityModule.priv_sprCancelTransaction. Vendor 
error#1 code is 0 ()
                                   securityModule.priv_sprCancelTransaction. Vendor 
error#2 code is 0 ()

Can any one help?


Bola

priv_pgCancel.java