A TLOBLocator created with the Create constructor always needs to be associated with a single database column value. You cannot read or write data until this association is made, either by fetching the LOB value or by returning an empty LOB with the returning clause in an insert or update statement.

A TLOBLocator created with the CreateTemporary constructor can hold data regardless whether it is associated with a database column or not. It is called temporary, because if you free it without writing it to the database, the data is gone.

The temporary data can either be cached on the client or on the server. What is most efficient depends on how the application accesses the data.