Function Sequence Error

[thecharlie]

Hey guys,

great forum! I have one question:

I've been trying to run this query but everytime I do, I get this error:

[Oracle][ODBC]Function Sequence Error(#0)

This is my query:

update summit_child, child_id

set summit_child.id = child_id.id, summit_child.child_first_name = child_id.child,
summit_child.child_last_name = child_id.last_child,
summit_child.child_birth_datedb = child_id.dob_child,
summit_child.sex_cd = child_id.gender_child, summit_child.child_seq_num
= switch(summit_child.child_seq_num = "1", "2",
summit_child.child_seq_num = "2", "3", summit_child.child_seq_num
= "3", "4", summit_child.child_seq_num is null or
summit_child.child_seq_num like " ", "1")

where summit_child.id = child_id.id
and child_id.child = summit_child.child_first_name
and child_id.last_child = summit_child.child_last_name;

any help would be very much appreciated