I have a table called IMAGE_TB with the following structure:
IMG_ID - PK
IMG_DESC
IMG_DATA - BLOB
IMG_EXTENSION
This table is stored in Oracle 11g R2 database. i am using ODP.NET to interact with the PL/SQL.
I am inserting image data into this table. I already know the values regarding the Image ID, the Image Description and Image Extension.
Now i am finding it difficult understanding of storing the IMG_DATA which the actual content of the image. In the C# i have binary[] array of image data which i want to pass to oracle so it can store the data.
Would I have to create a BLOB ARRAY in PL/SQL and pass multiple binary[] array of data to it.
e.g
create type BLOB_ARRAY as VARRAY(10) of BLOB;
Secondly, is there anything i need to be aware of when inserting BLOB Data?
What I have tried:
Inserted data without the Blob data using the following statement:
INSERT INTO IMAGE_TB(IMG_ID, IMG_DESC,IMG_EXTENSION)VALUES(1,'Mountain','.jpg');