Re: Cursor Parameter Problems/Question

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 09 Apr 2006 21:05:58 +0200
Message-ID: <e1blui$74g$03$1@news.t-online.com>

Dereck L. Dietz schrieb:
> I figured out my problem which brings up another question.
>
> For some reason the nvl function in my select statement was causing the
> problem. Can anybody suggest any reasons why that would be so?
>
>

For every field which you are referencing in your record,if this field is a function call, you should define an alias in corresponding cursor , like
cursor c_batting is ...
select
...
nvl(hits,0) hits,
...
from in_batting
...

Best regards

Maxim Received on Sun Apr 09 2006 - 14:05:58 CDT