Re: SQL-PL/SQL Problem (or is it me?)

From: <michael_bialik_at_my-deja.com>
Date: Sat, 11 Dec 1999 09:04:37 GMT
Message-ID: <82t434$bhe$1@nnrp1.deja.com>

Hi.

I just tried it and it worked OK ( 7.3.4 ). What is the error message?

Michael.

In article <go035sokrbdlktkv2hhthfmruoq67rr3km_at_4ax.com>, Jeff Kish <jeff.kish_at_ait-mmii.com> wrote:
> Hello.
>
> I have a pl/sql statement that works against Oracle 8.x databases, but
> fails against 7.3.4.
>
> Can someone help me here?
>
> Situation:
>
> Declaration is:
>
> v_PartCount number := NULL;
>
> STATEMENT ONE:
>
> SELECT count( * )
> INTO v_PartCount FROM partannot WHERE (partannot.mfgr_code =
> OEMCode) AND (partannot.part_num = OEMPartNumber)
>
> This works fine on Oracle 8.x, but fails on Oracle 7.3.4
>
> SELECT count( * )
> INTO v_PartCount FROM partannot;
>
> Works find on both;
>
> I tried v_PartCount number := 0; but no differences were observed.
>
> Thanks for your observations,
>
> Jeff Kish
> jeff.kish_at_ait-mmii.com
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 11 1999 - 03:04:37 CST