CODEWITHSUNDEEP
oracle-databasestored-procedures
HEEN
HEEN

Reputation: 4721

Error(57,5): PL/SQL: ORA-00984: column not allowed here for creating stored procedures

I have created a stored procedure but while compiling it, I am getting error as

Error(57,5): PL/SQL: ORA-00984: column not allowed here

Below is my query

create or replace PROCEDURE NEIQC_DATA_DUMP_MST AS 
BEGIN

execute immediate 'truncate table TBL_NEIQC_WF_SITE_MST';

INSERT INTO TBL_NEIQC_WF_SITE_MST

(
    OBJECTID,
    SAP_ID,
    NETWORK_ENTITY_ID    ,
    SITE_NAME            ,
    SITE_ADDRESS         ,
    MAINTENANCEZONE_CODE ,
    INVENTORY_TYPE       ,
    TYPE_NAME            ,
    SITE_STATUS_CODE     , 
    NE_MODIFIED_DATE     ,
    NE_MODIFIED_BY       ,
    CREATED_DATE         ,
    CREATED_BY           ,
    STRUCTURE_NAME       ,
    RJ_CITY_CODE         ,
    RJ_R4G_STATE_CODE    ,
    RJ_DISTRICT_CODE     ,
    RJ_TALUK_CODE        ,
    RJ_JC_CODE           ,
    RJ_JIOPOINT_SAPCODE  ,
    RJ_COMPANY_CODE_1    ,
    RJ_COMPANY_CODE_2    
)

VALUES

(
    OBJECTID                      ,
    RJ_SAPID,                      
    RJ_NETWORK_ENTITY_ID          ,
    RJ_SITE_NAME                  ,
    RJ_SITE_ADDRESS               ,
    RJ_MAINTENANCE_ZONE_CODE      ,
    '',
    TYPE_NAME                     ,
    'ACTIVE',
    RJ_LAST_MODIFIED_DATE,
    RJ_LAST_MODIFIED_BY ,
    SYSDATE,
    'SCHEDULER',
    STRUCTURE_NAME                ,
    RJ_CITY_CODE                  ,
    RJ_R4G_STATE_CODE             ,
    RJ_DISTRICT_CODE              ,
    RJ_TALUK_CODE                 ,
    RJ_JC_CODE                    ,
    RJ_JIOPOINT_SAPCODE           ,
    RJ_COMPANY_CODE_1             ,
    RJ_COMPANY_CODE_2          
);
 
COMMIT; 

END NEIQC_DATA_DUMP_MST;

please suggest what is wrong

Upvotes: 0

Views: 99

Answers (1)

hotfix
hotfix

Reputation: 3396

your insert Statement should look like 

INSERT INTO TBL_NEIQC_WF_SITE_MST

(
    OBJECTID,
    SAP_ID,
    NETWORK_ENTITY_ID    ,
    SITE_NAME            ,
    SITE_ADDRESS         ,
    MAINTENANCEZONE_CODE ,
    INVENTORY_TYPE       ,
    TYPE_NAME            ,
    SITE_STATUS_CODE     , 
    NE_MODIFIED_DATE     ,
    NE_MODIFIED_BY       ,
    CREATED_DATE         ,
    CREATED_BY           ,
    STRUCTURE_NAME       ,
    RJ_CITY_CODE         ,
    RJ_R4G_STATE_CODE    ,
    RJ_DISTRICT_CODE     ,
    RJ_TALUK_CODE        ,
    RJ_JC_CODE           ,
    RJ_JIOPOINT_SAPCODE  ,
    RJ_COMPANY_CODE_1    ,
    RJ_COMPANY_CODE_2    
)

select
    OBJECTID                      ,
    RJ_SAPID,                      
    RJ_NETWORK_ENTITY_ID          ,
    RJ_SITE_NAME                  ,
    RJ_SITE_ADDRESS               ,
    RJ_MAINTENANCE_ZONE_CODE      ,
    '',
    TYPE_NAME                     ,
    'ACTIVE',
    RJ_LAST_MODIFIED_DATE,
    RJ_LAST_MODIFIED_BY ,
    SYSDATE,
    'SCHEDULER',
    STRUCTURE_NAME                ,
    RJ_CITY_CODE                  ,
    RJ_R4G_STATE_CODE             ,
    RJ_DISTRICT_CODE              ,
    RJ_TALUK_CODE                 ,
    RJ_JC_CODE                    ,
    RJ_JIOPOINT_SAPCODE           ,
    RJ_COMPANY_CODE_1             ,
    RJ_COMPANY_CODE_2          
  from ne_structures -- if this is your table

;

Upvotes: 1

Related Questions