Re: SQR error

[Don Mellen <donm@ONTKO.COM>]

Just another shot in the dark, but from the sqrug archives (submitted by
Paul Cruz on July 6 1998)

"This is a known bug in Oracle RDBMS ver 7.2 ( not sure if it also exist
in 7.3). We encountered this same problem on a script (not written in SQR)
that does the same thing, loading from a flat file. Oracle Support should
be able to provide you a patch for it."

Another helpful entry might be a longer one by Charles Thompson, it can be
found in the archives at...
   http://www.sqrug.com/sqr-users/sqrusers_98q3/msg00034.html

As always, the archives can be found at http://www.sqrug.com

On Tue, 23 Jan 2001, Cadenas, Maria (MT) wrote:

> Guys,
>
> We get the error below when running the report in a real environment, but
> not in our testing environment. My gut instinct tells me that the issue is
> technical (amount of data in the real environment vs.. testing environment),
> but the Tech team thinks it's a problem with the SQR. We don't have any
> logic that causes the program to be cancelled within the program, and it's
> running on the server so the user cannot hit ctrl C and kill it. any ideas?
> suggestions?
>
>
> BEGIN-REPORT
> Report Began At: 08:49:27  01/18/01
> Loading Arrays Started...
> Arrays Loaded.
> (SQR 5528) ORACLE OFEN error 1013 in cursor 18:
>    ORA-01013: user requested cancel of current operation
>
> Error on line 2008:
>    (SQR 3725) Bad return fetching row from database.
>
> SQR: Program Aborting.
>

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"