OCI_INVALID_HANDLE when use user define type (bcb6)
Posted: 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
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