BLOB data can be inserted into an Oracle database table with BLOB datatype by the use of UTL_RAW.cast_to_raw( blob_data ) if the data is large plain text. |
To insert other types of BLOB data such as images, video file etc., it is done in a multi step process. First an EMPTY_BLOB() placeholder as to be created. The file has to be updated next. Here just the same plain text data is used. To upload a video file, etc., DBMS_LOB package features have to be used. |
74931