Problem trying to update a record with a value returned by a function
Date: 11 Feb 2004 14:36:32 -0800
Message-ID: <e151b418.0402111436.117a9e19_at_posting.google.com>
Hi all,
I am trying to update a record with a function value. Here is the
function:
update ITSM_SER_CUSTOM_FIELDS
When I run the statement:
select SLA_PENDING_DATE.GET_DL(2292,'servicecall') from dual;
I get a valid date returned.
If I modify my SQL statement to substitute "sysdate" for the function
value, the current date appears in the field.
Any ideas why is the date field not being updated in the db when I use
the function?
set SCF_SCDATE2 = SLA_PENDING_DATE.GET_DL(2292,'servicecall')
where SCF_SER_OID = (select SER_OID from ITSM_SERVICECALLS where
SER_ID = 2292);
When I run this statement, I get the message "1 row updated". After
doing a commit, I look at the record in question and the SCF_SCDATE2
field is blank.
Thanks for any help,
Bob
Received on Wed Feb 11 2004 - 23:36:32 CET