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.
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. |
TRUE if the operation succeeded, FALSE otherwise.
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.
sObjversion = DataRecordVersionGet( ) bOK = DbClobWriteFromFile( c_hSql, 'LOB_API.Write_Picture__', DataRecordIdGet( ), sObjversion , sFileName, nFileErrorCode )