Hello,
we have Problems to recompile a old Version of a Serviceprogramm
written in Visaul C++ 6. Now we have a 9.2.0.1.0 DB with a VS.NET
2003.
All we wanna do is call a Procedure with an insert into a Table.
like this:
EXEC SQL EXECUTE
BEGIN
SP_TRACER(:cProcName,
:TraceFehlerNr, :TraceLevelNr,
:cTraceText, :cDescription, TRUE);
commit;
exception
when others then
rollback;
:ErrStatus := SQLCODE;
:cFehler := substr(SQLERRM,1,80);
END;
END-EXEC;
the DB trace looks like that:
begin LOGIS . SP_TRACERC ( :cProcName , :TraceFehlerNr , :TraceLevelNr
,
:cTraceText , :cDescription , 1 ) ; commit ; exception when others
then
rollback ; :ErrStatus := SQLCODE ; :cFehler := substr ( SQLERRM , 1
, 80 )
; END ;
call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 11 0.00 0.00 0 0 0
0
Execute 0 0.00 0.00 0 0 0
0
Fetch 0 0.00 0.00 0 0 0
0
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 11 0.00 0.00 0 0 0
0
no execute!
We have tried to commit inside the Procedure but nothing else. No
Error but no insert!
We have tried a direct insert nothing happens.
Any Idea?
greatings Oliver