You have not mentioned what version of Oracle you are using. The solution which I can suggest is Instead of prepare try with "do" or upgrade Oracle 10.0 or to Oracle 9.2.0.2