inserting plain text into LOB in Oracle

Hello all

I need to insert rows into an Oracle table which contains a BLOB field (Oracle 8.1.7 on win2k).
The data I want to insert is just text, and its not very large at this time.
This is gonna be part of an installation program so I wont be able to access any files on the disk.
Given those conditions, and reading older posts I realize that I cannot use dbms_lob, since It only helps accessing disk files.

I will be using PL/SQL. Is there a way to just insert constant text into a BLOB field (like "insert into table values (1,'hello world')") ?

Thanks

Guy Received on Tue Apr 01 2003 - 01:54:57 CST