vs.net pro*c insert failed

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Oliver G

    vs.net pro*c insert failed

    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(:cPro cName,
    :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
Working...