Stacey
Try replacing the last parameter (chgd_on) with NULL instead of "" (empty
string).
HTH
Martin
insert into fw_programme_cell(cell_id
, programme_hdr_id
, treat_length_id
, fw_year
, reason_note
, added_on
, added_by
, chgd_on)
select :p_new_cell_id
, :p_to_id
, treat_length_id
, fw_year
, reason_note
, today
, user
, ""
from z_fw_programme_cel
where cell_id = :p_cell_id
"WS SMTP relay" made the following
annotations on 10/18/00 10:34:54
------------------------------------------------------------------------------
[INFO] -- Content Manager:
[MMSSOV] This e-mail message and any attachments are confidential to Sovereign Limited
and subsidiaries and subject to legal privilege. If you have received this e-mail in
error, please advise the sender immediately and destroy the message and any
attachments. If you are not the intended recipient you are notified that any use,
distribution, amendment, copying or any action taken or omitted to be taken in
reliance of this message or attachments is prohibited.
==============================================================================
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
