I am facing the coding proble in the following Stored Procedure wherein I am trying to create a table after deleting it. and then I am trying to insert records from two other tables based on certain condition. I am getting error(s) in it.
Can someone help me in solving it.
Regards

=============== =============== =============== ========
[code=oracle]

CREATE OR REPLACE PROCEDURE TMPDUMP IS
...