vs.net pro*c insert failed

From: Oliver G <oliver.gassner_at_web.de>
Date: 14 Jun 2004 05:05:23 -0700
Message-ID: <eabb4cb1.0406140405.272146ac_at_posting.google.com>

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 Received on Mon Jun 14 2004 - 14:05:23 CEST