Previous to 8.5, you would write an External Action Block (EAB) or a user-added function. With 8.5 and the addition of the Inline Code statement in the Action Diagram, you should be able to accomplish what you need to do from within the model.
Can you be more specific about what Oracle functions you would like to call?