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

Just figured out what the problem is.

1st, error was a 6502.
2nd This happened because my routines input parameters where mixed up, i.e. (inColumn1 table.Column2%type, inColumn2 table.Column1%type)

What worries me is that Oracle 8.x did not thrown an error, and it probably should have.

Thanks for responding,
Jeff

On Sat, 11 Dec 1999 09:04:37 GMT, michael_bialik_at_my-deja.com wrote:

>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 Wed Dec 22 1999 - 07:49:28 CST