Passing a record to a Java Stored Procedure

I wish to be able to pass a whole record eg table% rowtype to a Java Stored Procedure (method) and have the Java method calculate a CRC/Hash key to be returned by the function. Environment is Oracle 8.1.5 on Solaris.

The problem is that at the PL/SQL - Java inteface where I delcare the data types the PL/SQL wrapper function won't allow a rowtype to be a parameter [message is PLS-00999 "Functionality Not implemented yet" or nearabouts]

Ideally I would like to pass in a whole record from any table - this would allow me to detect record change at high speed inside the "history" procedures of a Datawarehouse! Currently we detect changes on a field by field basis big-wide tables are too slow....

The interfacing between PL/SQL and Java is all a mystery to me - any information or suggestions gladly accepted?....

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 21 2000 - 00:00:00 CDT