Ora8LobGetLength Function

Action

Gets the length of a LOB.

Include file

Ora8.bdh

Syntax

Ora8LobGetLength( in  hSvcCtx : number,
                  in  hLobLoc : number,
                  out nLength : number optional ) : boolean;

Return value

  • true if successful

  • false otherwise

Parameter Description
hSvcCtx An initialized service context handle.
hLobLoc A LOB locator that references the LOB.
nLength Variable receiving the length of the LOB (optional).

Example

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

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

    ...

    Ora8LobGetLength(ghSvcCtx0, ghDescriptor0, nLen);

    ...

    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: OCILobGetLength