Passing LOBs in stored procs

[Greg Stevenson]

If a passed in value is nil/null is TLobLocator.Create sufficient or should one still use TLobLocator.CreateTemporary?

If a non-nil/null empty string is passed in is it ok to do a SetEmpty after a CreateTemporary?

 

[Marco Kalter]

You should always use TLOBLocator.CreateTemporary if the LOB is treated as a temporary LOB inside the stored procedure.

For temporary LOB's you no longer need SetEmpty. You can simply assign an empty string to its AsString property, or truncate it.