Page 1 of 1

OCI_INVALID_HANDLE when use user define type (bcb6)

Posted: Wed 13 Sep 2006 13:58
by yhviqd
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

Posted: Thu 14 Sep 2006 13:30
by Plash
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.