hi,

Thanks a lot for all your earlier responses!

This occasion I am taking up a new error (ORA-03113) which is occuring intermittently whenever I am using Native Dynamic SQL (execute immediate) to create views inside a PL/SQL procedure. However if I replace NDS with Dynamic Sql then it works absolutely fine.
I don't want to use dynamic sql because of its slow speed.


I am giving below the exact error message :

ERROR at line 1:
ORA-03113: end-of-file on communication channel

thanks
Paul