hi all,

i am getting ora-03113:end of file on communication channel , after running a pl/sql procedure which creates number of tables/indexes all through dynamic queries(execute immediate).
I am running this pl/sql procedure from my own user and all the new tables are getting created properly but at some point ora-03113 is getting generated and the connection is terminated by oracle after this error. If i dont run this procedure then everything is working fine and my other procedures are running fine too. The only difference between this failing procedure and others is that i am using lots of "execute immediate" statements and DBMS_SQL.EXECUTE(v_cursorid) command to dynamically create tables.

The oracle server has recently been shifted from 8i to 9i and i am getting this error only after running this procedures on the new 9i server(standard edition). The same procedure used to run fine in 8i.

Pls suggest what's going wrong and how to solve this problem.

thanks

Parijat Paul