Ora8LobWrite Function

Action

Writes data into a LOB.

Include file

Ora8.bdh

Syntax

Ora8LobWrite( in  hSvcCtx      : number,
              in  hLobLoc      : number,
              in  nSizeOfPieces: number,
              in  nSizeToWrite : number,
              in  nStartOffset : number,
              in  nCharsetID   : number optional,
              in  nCharsetForm : number optional,
              out nCntWritten  : number optional ) : boolean;

Return value

  • true if successful

  • false otherwise.

Parameter Description
hSvcCtx The service context handle.
hLobLoc An internal LOB locator that references the LOB.
nSizeOfPieces Size of pieces to write.
nSizeToWrite Cumulated size to write.
nStartOffset Start offset for first piece.
nCharsetID Charset ID (optional).
nCharsetForm Charset form (optional).
nCntWritten Count written (optional).

Example

var
  ghEnv0        : number;
  ghError0      : number;
  ghStmt0       : number;
  ghSvcCtx0     : number;
  ghDescriptor0 : number;

dcltrans
  transaction TMain
  begin
    Ora8Init(ghEnv0, OCI_DEFAULT);
    Ora8HandleAlloc(ghEnv0, ghError0, OCI_HTYPE_ERROR);
    Ora8Logon(ghEnv0, ghSvcCtx0, "user", "password", "orclnet2");

    ...

    Ora8LobWrite(ghSvcCtx0, ghDescriptor0, 100, 30000, 0);

    ...

    Ora8Logoff(ghSvcCtx0);
    Ora8HandleFree(ghError0, OCI_HTYPE_ERROR);
    Ora8HandleFree(ghEnv0, OCI_HTYPE_ENV);
  end TMain;

See also

Oracle's Programmer's Guide to Oracle Call Interface for Wrapped Oracle functions: OCILobWrite