Can anybody find out what is wrong with this procedure. I am using dynamic sql. By using execute immediate the sql's are not getting executed. If i comment out the execude immediate and put DBMD_OUTPUT.PUTLINE(....) those are getting executed.
Can anybody find out if anythis is wrong with the way i have prepared the sql statements.