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

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 - 18:00:12 CET