PL/SQL (MOSC)

MOSC Banner

PLS-00103 Error

edited Nov 10, 2015 10:14AM in PL/SQL (MOSC) 7 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center