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 in their stored procs and I’m not sure if they are supported. It would be great to use them since instead of passing in 20 or so arguments to a stored proc, i’d just pass an object.
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 ?