Insert blank blob data in oracle using c

Question

I am trying to insert blank data in blob column of table using C program in oracle database but it is inserting as Null, How to make it blank instead of null.data type is lpBlob.

Answer 1

Depending on your definition of "blank", my assumption is that you want to use the empty_blob function

INSERT INTO table_name( ..., blob_column_name )
  VALUES( ..., empty_blob() );