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

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 Received on Fri Dec 10 1999 - 16:53:16 CST