Newbie question - Oracle Trace Results
Date: Wed, 9 Apr 2008 07:57:20 -0700 (PDT)
Message-ID: <1be31291-49bd-4e24-88bc-33dabf0fb7e8@u12g2000prd.googlegroups.com>
Hi,
First time post so be gentle :)
When looking at a trace file, does the adsence of an Exec, as in the following
PARSING IN CURSOR #1 len=3523 dep=0 uid=32 oct=3 lid=32
tim=30556916889618 hv=3499698552 ad='a6a67068'
{SQL Select Statement - Not included due to length of 3000+ chars}
END OF STMT
PARSE
#1:c=100000,e=148774,p=7,cr=425,cu=0,mis=1,r=0,dep=0,og=4,tim=30556916889610
indicate that the SQL statement was not executed?? The PARSE.. statement was the last line in the Trace file. If so, is there anyway to find out why?
I have a Windows application that uses SQLExecDirect to execute SQL
statement on a Oracle 8i dbase.
It seems to be that when the SQL statement is of a certain size, the
application just aborts.
The issue is that we have identical Application, Oracle Client, Oracle server and drivers on different Customer sites and on some sites the application works and others it does not.
Regards Received on Wed Apr 09 2008 - 09:57:20 CDT