Re: Problem trying to update a record with a value returned by a function
From: Bob M <rjm2004_at_shaw.ca>
Date: 12 Feb 2004 20:23:24 -0800
Message-ID: <e151b418.0402122023.1f108e5_at_posting.google.com>
Date: 12 Feb 2004 20:23:24 -0800
Message-ID: <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 Received on Fri Feb 13 2004 - 05:23:24 CET
