Re: Problem trying to update a record with a value returned by a function

From: Dave <davidr21_at_hotmail.com>
Date: 13 Feb 2004 09:00:12 -0800
Message-ID: <8244b794.0402130900.532c040d@posting.google.com>

rjm2004_at_shaw.ca (Bob M) wrote in message news:<e151b418.0402122023.1f108e5_at_posting.google.com>...
> > Bob -
> >
> > For giggles, try this and see what you get as a result...
> >
> > SELECT SLA_PENDING_DATE.GET_DL(2292,'servicecall')
> > FROM ITSM_SER_CUSTOM_FIELDS
> > where SCF_SER_OID = (select SER_OID from ITSM_SERVICECALLS where SER_ID = 2292);
> >
> > Dave
>
> Dave,
>
> This select statement returns a date.
> The same if I perform a select function(p1,p2) from dual.
>
> Bob

Bob -

I'm stumped. Another thought at isolating the problem....use the NVL function as shown below. If the column is updated with the hard-coded date, this would further prove your function IS returning NULL in this context.

update ITSM_SER_CUSTOM_FIELDS
set SCF_SCDATE2 = NVL(SLA_PENDING_DATE.GET_DL(2292,'servicecall'), TO_DATE('3000/12/31', 'YYYY/MM/DD'))
where SCF_SER_OID = (select SER_OID from ITSM_SERVICECALLS where SER_ID = 2292); Dave Received on Fri Feb 13 2004 - 11:00:12 CST