Home » Developer & Programmer » Precompilers, OCI & OCCI » Problem in Open cursor statement
Problem in Open cursor statement [message #94027] Tue, 14 October 2003 10:49 Go to next message
Saket
Messages: 1
Registered: October 2003
Junior Member
My problem is that to open a particular cursor from a pro*cobol programme it is taking a lot of time(> 24 hrs). The same sql statement when run from a sql prompt takes less than 2hrs.

The particular sql has 4 table joins and the largest table to be scanned has around 130 Million rows.

I am using Oracle 8.1.7 on HP Unix 11.

Can any one suggest what could be the problem ?
Re: Problem in Open cursor statement [message #94028 is a reply to message #94027] Tue, 14 October 2003 12:19 Go to previous message
kiran
Messages: 503
Registered: July 2000
Senior Member
will you please send me the exact cursor code ..
did the program finally ended successfully?
Previous Topic: ORA 1036 illegal variable name/number
Next Topic: Trace ORA-3113
Goto Forum:
  


Current Time: Thu Jun 30 10:40:40 CDT 2022