BEGIN
INSERT INTO bss_information
(AgentID,
Agent_busy,
Agent_idle,
Agent_total,
Agent_working,
Busy_rage,
MachineIP,
Queue_in_call,
Queue_out_call,
Queued_call,
Sample_time,
Skill_queue,
Success_rate)
VALUES
('1001',
0,
2,
4,
2,
0,
'134.140.56.91',
21565,
60,
0,
to_date('2007-09-29 15:24:28', 'yyyy-mm-dd hh24:mi:ss'),
31,
0);
COMMIT;
EXCEPTION
WHEN dup_val_on_index THEN
UPDATEbss_information
SET Agent_busy = 0,
Agent_idle = 2,
Agent_total= 4,
Agent_working= 2,
Busy_rage= 0,
Queue_in_call= 21565,
Queue_out_call = 60,
Queued_call= 0,
Sample_time= to_date('2007-09-29 15:24:28',
'yyyy-mm-dd hh24:mi:ss'),
Success_rate = 0
WHERE AgentID = '1001'
and MachineIP = '134.140.56.91'
and Skill_queue = 31;
COMMIT;
END;
为什么说这个语句没有绑定变量呢?
|