The details of the problem is as follows:
1- An old database containing a column of type OrdVideo
2- I don't want to use OrdVideoDomain to access it. All I need is to get the content of the file - file bytes -.
3- I am using ResultSet to get the data. For the OrdVideo column I am not sure what to call or use. I was able to use rs.getObject("columnName") which returns STRUCT. I never worked with that and don't know how to get the values from it. Also I don't know how to convert or cast this column into OrdVideoDomain successfully.
what I need is to get the information or the bytes representing the stored file without using an OrdVideoDomain or - if I have to - just show me how to cast the column into an OrdVideoDomain successfully.
I am assuming the video content is stored in a BLOB in ORDVideo, not BFILE. The easiest way is to access the BLOB locator using getBLOBContent(). See the Oracle Multimedia Java API Reference for more details (http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10779/toc.htm).