Re: problem running sqr v2.4 against Oracle 7.1.6.2 on SunOS

[Sean Molloy <seanm@bwc.org>]

  Sorry I wasn't clear about that, the problem occurs for any sql 
statement in an sqr program that references a numeric (#variable) in the 
Where clause. It does not matter whether the where clause has rownum or 
not. The program I provided was only to demonstrate the problem.

  I tried using the round(#var) construct but I still got the 'numeric 
error'.

  I realise that this problem may not occur on later releases ( > v2.4) 
of sqr on SunOS, but I have no access to these in order to check 
them. I have only been able to verify that sqr v2.27 and v2.4 for SunOS 
have this problem with Oracle 7.1.6.2 on SunOS unix.

  Also I have relinked the v2.4 sqr using the Oracle 7.1.6.2 libraries, 
but the problem still exists.

  All of our sqr programs have worked perfectly well with Oracle 7.1.4.1, 
7.0.16 and 6.0.33 previously.

 Sean

On Tue, 10 Oct 1995, Ray Ontko wrote:

> Date: Tue, 10 Oct 1995 09:46:58 -0600
> From: Ray Ontko <rayo@ontko.com>
> To: seanm@bwc.org
> Subject: Re: problem running sqr v2.4 against Oracle 7.1.6.2 on SunOS]
> 
> Sean, 
> 
> I don't have access to a Sun running SunOS and 7.1.6.x.x, but
> here's an idea:  try using "rownum < round(#k)"
> 
> I'm wondering if automatic data conversion or some other data type
> issue is getting in your way.  Does this happen with rownum only
> or also when you compare to bona-fide numeric columns?
> 
> Ray
>