This content has been marked as final. Show 4 replies
I think that is a User Defined Type, right?
You can open up Server Explorer, find the User Defined Type node, find the OrdVideo definition, and then from the menu choose "Create Custom Class"
Here is a walkthrough that will help you get started with User Defined Types:
thanks to your answer, I was able to figure it out. I converted the video to BLOB using sql:
select MyVideoColumn.source.localData from MyTable
and when inserting the value I used
insert into MyTable Values(ORDSYS.ORDVideo( 'desc', ORDSYS.ORDSOURCE(:0,NULL, NULL, NULL, NULL, NULL), NULL,NULL, EMPTY_CLOB(), 0, 0, 0, 0, 0, 0, NULL, 0, 0))
and passing the blob object as the :0 parameter
Hi, I'm trying to do something like this, I'd like to insert binary data (images, videos, ...) into my OracleDB 11g using the famous ORDs from java but I could'n do it, could you please post here some code example(not necessary in java) or some guide to help me ???