SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create a Blob with binary numbers

783320Jul 6 2010 — edited Jul 6 2010

Hi all,

I need to translate, in a pl sql procedure, a cobol procedure that creates a binary file containing a list of 7 digits numbers (3 bytes for every number).
Is it possible to write a blob cointaining a list of 3 byte numbers ??
Is the DBMS_LOB.WRITE
(lob_loc IN OUT BLOB,
amount IN BINARY_INTEGER,
offset IN INTEGER,
buffer IN RAW)

the right function?
And how to trasform the number in 3 bytes raw data type (the "buffer" parameter of dbms_lob.Write function)??
A lot of questions but I'm very confused ...

Tanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2010

Added on Jul 6 2010

1 comment

641 views