>I need to replace a single quote character in a string with two single quote characters so that Oracle will update correctly.
>CHRTRAN([O'BRIEN],['],['']) doesn't work... what will?

Try

STRTRAN([O'BRIEN],['],[''])