PLS-00103 Error
Hello All,
I was trying to use dynamic sql in a stored procedure as below
CREATE OR REPLACE PROCEDURE proc_xyz AS BEGIN EXECUTE IMMEDIATE 'drop table t_xyz'; EXECUTE IMMEDIATE 'create table t_xyz AS SELECT TT.TC_IID, TER.T_NO MER.M_NO, MER.M_NAME, MER.ADDR, C.Customer_NAME, TTA.TXN_TYPE, TTA.QUANTITY, TTA.AMOUNT, TTA.ENTITY_IID FROM TC_TXN TT, TC_SELECT TS, REPORT_TXN RPT, TC_AMOUNT TTA, MEDIA MD, MERMP MER, TERMP TER, CUSTOMER CORP, CAMP CAM WHERE TT.TC_SELECT_IID = TS.TC_SELECT_IID AND TT.TC_TXN_IID = RPT.TC_TXN_IID AND TT.TC_TXN_IID = TTA.TC_TXN_IID (+) AND TT.MEDIA_IID = MD.MEDIA_IID (+) AND TT.MERMP_ID = MER.MERMP_ID (+) AND TT.TERMP_ID = TER.TERMP_ID (+) AND TTA.AUX_ENTITY_IID = CAM.CAMP_ID (+) AND REPORT_ELIG = 1 AND TT.TXN_TYPE NOT IN (19,
0