| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Problem trying to update a record with a value returned by a function
> 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 Thu Feb 12 2004 - 22:23:24 CST
![]() |
![]() |