I'm still haveing trouble with using stored procedures, but I think it is the Schema we are connecting too, APPS has too many Stored Procedures, and the Web part times out when trying to create a list for the methods.
We're working on having a Webparts Schema for us to put stored procedures and view into and connect to the Oracle DB with that schema.
Kathy