Hi,
i am a newby to Oracle and i would like to ask some opinion with the
situation i encountered.
I am trying to load a block of data ( it is EBCDIC code and may have
null value in the data block ) into a BLOB field inside Oracle with
Pro C. i had a store procedure made to insert the PK and data to a
BLOB.
Here is what i know so far:

1. i need to create an empty blob locator into the blob field and then
retrieve the locator for loading the actual data.
2. i am trying to use OCI to contain the locator since C++ doesn't
have BLOB type. However, OCI seems not working with BLOB type but
CLOB.

Based on that, i assume that OCI could not do the job. So i start to
look into another possibility: do all the insertion and update to BLOB
inside a store procedure and here comes the questions:

if a store procedure is created to do the job inside the database,
that mean i will have to pass the data block in to the store
procedure. I would assume that would be a RAW data type in Oracle.
However, the data might be stored in a BYTE array in C++. Are there
any implicit conversion between BYTE array ( since it could contain
NULL value as part of data, can't use string or VARCHAR for it ) data
type to Oracle RAW data type?
If not, what should do to make it work?

thanks!