Converting Data Types to LOB Data Types

Can I Insert or Update Any Length Data Into a LOB Column?

Question

Can I insert or update any length of data for a LOB column? Am I still restricted to 4K. How about LOB attributes

Answer

When inserting or updating a LOB column you are now not restricted to 4K.

For LOB attributes, you must use the following two steps:

1. INSERT empty LOB with the RETURNING clause

2. Call OCILobWrite to write all the data

Does COPY LONG to LOB Work if Data is > 64K?

Question

Example: Copy Long to LOB Using SQL :

INSERT INTO Multimedia_tab (clip_id,sound) SELECT id, TO_LOB(SoundEffects) 

Does this work if the data in LONG or LONGRAW is > 64K?

Answer

Yes. All data in the LONG is copied to the LOB regardless of size.