Thread Subject: Database insert java/oracle object directly

Hi all,

I have the database toolbox, and I connect to an oracle database. When I query/fetch from my table, I get an oracle.sql.STRUCT object returned (this is the correct behaviour - I'm fetching oracle SDO_GEOMETRY). What I want to do, is to somehow *use that struct* (which I think is a java object) in an oracle INSERT.

Ie,

>> curs = exec(conn,'SELECT mygeom FROM mygeomtable');
>> curs = fetch(curs);
>> oraIn = curs.Data{1}
oraIn =
oracle.sql.STRUCT@1bd96c8

Does anyone know a way to work *with* this oracle.sql.STRUCT@1bd96c8 object, and send it back to the database?

Ie, something like:
>> curs = exec(conn,'INSERT INTO mygeomtable VALUES (?)', oraIn);

The reason I want to do this, is so that I can upload more complex geometry directly, rather than converting it to a flat SQL string (which has limitations on the size of geometry I can upload).

Please let me know if you have any hints on this.
Thanks,
Sven.

Since you are using Oracle GIS extension, you really have to use pure Java to manipulate these Oracle objects. Look at Oracle's documentation on how to insert these Oracle specific (Java) datatype into the database. Good luck!

Ed.