I read an interesting article in javaworld about integrating Oracle Objects ‘seamlessly’ with Java ones (see http://www.javaworld.com/javaworld/jw-06-2003/jw-0613-oracle9i.html), and am currently investigating a way of integration with a clients existing Oracle stored procedures. This client is using Oracle objects and I’m not sure if they are supported.
I imported the schema in the example into my Oracle 9i database and tried setting up a stored procedure with signatures service, and it doesn’t quite seem to work. I get parameter errors when I try and invoke my service (which does at least get set up). I’m wondering if this will even work. Has anyone else had experience with this ?