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.

define blank - short answer, fill your blob with 0x20 (that's spaces) — KevinDTimm
– KevinDTimm, Commented Mar 15, 2013 at 18:27

Justin Cave · Accepted Answer · 2013-03-15 18:28:37Z

4

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() );

answered Mar 15, 2013 at 18:28

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

user1773207 Over a year ago

I am not using sql, I am inserting the data using C program

Justin Cave Over a year ago

@user1773207 - Presumably, your C application is issuing SQL statements (either directly or via some client API). If you want to insert an empty BLOB, you'd need to use the empty_blob function.

user1773207 Over a year ago

I tried to fill blob with blank but still it is inserting null in oracle, Is there any function in C like java to insert empty blob.

Justin Cave Over a year ago

@user1773207 - What API are you using? OCI? OCCI? Something else? Can you edit your question to include the code that you're using?

user1773207 Over a year ago

I am using OCI API, same code is working for other database(SQL server /DB2) but for oracle database it is inserting as NULL in blob field.

|

Collectives™ on Stack Overflow

Insert blank blob data in oracle using c

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related