OCI_INVALID_HANDLE when use user define type (bcb6)

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yhviqd
Posts: 1
Joined: Wed 13 Sep 2006 13:50

OCI_INVALID_HANDLE when use user define type (bcb6)

Post by yhviqd » Wed 13 Sep 2006 13:58

CREATE OR REPLACE TYPE T_DEVLIST IS TABLE OF VARCHAR2(32);
PROCEDURE CHECKSTBSALABLE(ACMP VARCHAR2,ADPT VARCHAR2,AIN T_DEVLIST,AINTP T_DEVLIST,AOUT OUT T_DEVLIST,AOUTTP OUT T_DEVLIST);

TOraNestTable *arIn;
arIn=spStbSale->Params->ParamByName("AIN")->AsTable ;
arIn->AllocObject(_OraSession->OCISvcCtx,"T_DEVLIST");//error OCI_INVALID_HANDLE _OraSession->OCISvcCtx is not null pointer

it's ok with v4.50 ,but show error OCI_INVALID_HANDLE with v5.70

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 14 Sep 2006 13:30

We cannot reproduce the problem. Please specify full version of ODAC including build number (see Odac\About ODAC in Delphi menu). If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

Post Reply