i have problem with reading temporary table from oracle in Delphi 2005 with Odac 6.
EnableIntegers = True
EnableNumbers=False
I connet to Oracle 9 database and use Oracle 10g Client dll
temporary table
CREATE GLOBAL TEMPORARY TABLE "STANY_TMP"
( "TOW_KOD" VARCHAR2(6 BYTE),
"FIR_KOD" VARCHAR2(6 BYTE),
"KH_KOD" VARCHAR2(6 BYTE),
"STAN" NUMBER,
"CENA" NUMBER,
"CE" NUMBER,
"VAT_KOD" VARCHAR2(6 BYTE),
"VAT" NUMBER,
"STATUS" VARCHAR2(30 BYTE)
) ON COMMIT DELETE ROWS;
FSProc:=TOraStoredProc.Create(nil);
FSProc.session:=FSession;
FSProc.StoredProcName:='test.insertproc1';
FSProc.Prepare;
FSProc.ExecProc;
FSProc2:=TOraStoredProc.Create(nil);
FSProc.session:=FSession;
FSProc.StoredProcName:='test.insertproc2';
FSProc.Prepare;
FSProc.ExecProc;
FQuery_stany_tmp:=TOraQuery.Create(nil);
FQuery_stany_tmp.Session:=Fsession;
FQuery_stany_tmp.SQL.Add('SELECT STAN, CENA, VAT FROM stany_tmp WHERE FIR_KOD=:FIR_KOD');
FQuery_stany_tmp.ParamByName('FIR_KOD').AsString:=AFilKod;
FQuery_stany_tmp.Open;
if FQuery_stany_tmp.RecordCount>0 then
Cena:=FQuery_stany_tmp.FieldByName('CENA').asCurrency //<here float to curency error
All returnet data is always 0 (cena, vat, stan ) or very very small floating 1,89e-308. So when i convert to Currency i get error. I am 100% sure that in table are data and have value grater 0.