Database Software

Hi All,

Using the new in 11g byte[] JGeometry.store( JGeometry ) method as oppose to the traditional STRUCT JGeometry.store( JGeometry, Connection) method fails for certain SQL statements.


It works fine for statements like this:
UPDATE PARCELS SET GEOM = ? WHERE ID = 47;

These statements give errors though:

UPDATE PARCELS SET GEOM = SDO_MIGRATE.TO_CURRENT( ?, (SELECT DIMINFO FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'PARCELS' AND COLUMN_NAME = 'GEOM') ) WHERE ID = 47;

ORA-06553: PLS-306: wrong number or types of arguments in call to 'TO_CURRENT'

SELECT ID, LABEL, GEOM FROM PARCELS WHERE SDO_NN( GEOM, ?, 'SDO_BATCH_SIZE=5000' ) = 'TRUE';

ORA-29900: operator binding does not exist
ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_NN'


? Being where I bind in the byte[] / Object as appropriate.

So I get the above errors when using setBytes( index, JGeometry.store( jgeom ) ); but it work when using: setObject( index, JGeometry.store( jgeom, con ) );

Is this a bug is known / will be fixed ?

Thanks,
Ronan