Ora8DescriptorFree Function

Action

Deallocates a previously allocated descriptor.

Include file

Ora8.bdh

Syntax

Ora8DescriptorFree( in hDescriptor : number,
                    in nType       : number) : boolean;

Return value

  • true if successful

  • false otherwise

Parameter Description
hDescriptor An allocated and initialized descriptor that should be freed.
nType

Specifies the type of the given descriptor.

Could be one of the following:

  • OCI_DTYPE_SNAP

  • OCI_DTYPE_LOB

  • OCI_DTYPE_FILE

  • OCI_DTYPE_ROWID

Example

var
  ghEnv0        : number;
  ghError0      : 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");
    
    Ora8DescriptorAlloc(ghEnv0, ghDescriptor0, OCI_DTYPE_SNAP);

    ...

    Ora8DescriptorFree(ghDescriptor0, OCI_DTYPE_SNAP);
    Ora8HandleFree(ghStmt0, OCI_HTYPE_STMT);
    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: OCIDescriptorFree