Hi All, In the same line i have another problem. Using DBI modules "execute" function when i tried to created a relatively smaller procedure I was able to create it. But with the same "execute" function when i tried creating a procedure which is a bit larger in size (1100 lines) its the function is cribbing with an oracle error number 24344 and corresponding description says ORA-00000 normal, successfull completion. When I refered to the error cause i found that it was a compilation error. But when I ran the same procedure using "@" operator in SQL prompt procedure got created without any compilation error. What could be the reason and how to solve / overcome it ?