Ora8ParamSet Function

Action

Used to set a complex object retrieval (COR) descriptor into a COR handle.

Include file

Ora8.bdh

Syntax

Ora8ParamSet( in hHandle     : number,
              in nType       : number,
              in hParamDesc  : number,
              in nDescType   : number,
              in nPosition   : number ) : boolean;

Return value

  • true if successful

  • false otherwise

Parameter Description
hHandle Target handle.
nType Specifies the type of the handle.
hParamDesc Descriptor to be set.
nDescType Specifies the type of the descriptor. The descriptor type for a COR descriptor is OCI_DTYPE_COMPLEXOBJECTCOMP.
nPosition Position number.

Example

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

dcltrans
  transaction TMain
  const
    PUBLIC_KEY := "\h59b20094...";
  begin
    Ora8Init(ghEnv0, OCI_DEFAULT);
    Ora8HandleAlloc(ghEnv0, ghError0, OCI_HTYPE_ERROR);
    Ora8Logon(ghEnv0, ghSvcCtx0, "user", "password", "orclnet2");
            
    Ora8ParamSet(ghCOR, OCI_HTYPE_COMPLEXOBJECT, ghDescriptor0, OCI_DTYPE_COMPLEXOBJECTCOMP, 1);

    ...

    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 function: OCIParamSet