your application needs to be taf aware to perform this task. You need to code your application to peform this function, no way around it.

You can implement things like select failover but in terms of dml
, calling stored procs etc oracle will not perform this task

steve