DbClobWriteFromFile

Note: This page includes content based on the F1 documentation for Centura development. It may be partially converted to support APF development, but should be regarded to be of uncertain actuality. It is provided as is. Eventually, it should be replaced by documentation available from within Visual Studio.

public SalBoolean DbClobWriteFromFile(SalSqlHandle hSql, SalString sMethodName, SalString sObjid, 
                                      ref SalString sObjversion, SalString sFileName, ref SalNumber nFileErrorCode)

The DbClobWriteFromFile method writes (streams) a CLOB from a file to the database using a PL/SQL procedure.

Parameters

Name Description
hSql Handle that identifies the database connection
sMethodName PLSQL method that updates the CLOB.
sObjid OBJID to the record the CLOB should be written to
sObjversion OBJVERSION to the record the CLOB should be written to. Normally, the PLSQL method uses this to lock the record for update and returns the new objversion if the update succeeded.
sFileName The file name the CLOB should be written from.
nFileErrorCode If an error was caused by the file I/O operation, the value is a VTERR_* error code.
If the operation completed successfully, the value is VTERR_Ok.

Returns

TRUE if the operation succeeded, FALSE otherwise.

Comments

The PL/SQL method must have a certain list of arguments in order to work with the DbClobWriteFromFile method. Details and examples can be found in the Large Objects section in Development Guide for IFS/Base Server.

Example

sObjversion = DataRecordVersionGet(  ) 
bOK = DbClobWriteFromFile( c_hSql, 'LOB_API.Write_Picture__', DataRecordIdGet( ), sObjversion , sFileName, nFileErrorCode )