CODEWITHSUNDEEP
oracle-databasestored-procedures
HEEN
HEEN

Reputation: 4721

procedure compiling in oracle is not working

I have written below procedure in oracle but its getting compiled with error.

CREATE OR REPLACE PROCEDURE PROC_MIGRATE_ONEIBER 

AS 

BEGIN

-- EXECUTE PROCEDURE ONEFIBER_LNK_MIGRATE;

  execute ONEFIBER_LNK_MIGRATE;

  execute ONEFIBER_LNK_MIGRATE_CITY;
  
  execute ONEFIBER_LNK_MIGRATE_NLDC;
  
  END;
  


--  NULL;
END PROC_MIGRATE_ONEIBER;

I have to execute 3 procedures in one main procedure without any IN or OUT parameters. But its not working

Upvotes: 0

Views: 343

Answers (1)

Popeye
Popeye

Reputation: 35900

Just remove the execute keyword. Whenever you want to call another procedure within the procedure you can directly use the procedure name and parameters, If any.

CREATE OR REPLACE PROCEDURE PROC_MIGRATE_ONEIBER AS
BEGIN

-- EXECUTE PROCEDURE ONEFIBER_LNK_MIGRATE;
    ONEFIBER_LNK_MIGRATE;
    ONEFIBER_LNK_MIGRATE_CITY;
    ONEFIBER_LNK_MIGRATE_NLDC;
    --END;

--  NULL;
END PROC_MIGRATE_ONEIBER;
/

Update: Check this small code of how it should be. All procedures created in this answer are just for demo. (Make sure that the procedure that you are calling is not INVALID)

SQL>
SQL> CREATE OR REPLACE PROCEDURE ONEFIBER_LNK_MIGRATE AS
  2  BEGIN
  3  NULL;
  4  END;
  5  /

Procedure created.

SQL>
SQL> CREATE OR REPLACE PROCEDURE ONEFIBER_LNK_MIGRATE_CITY AS
  2  BEGIN
  3  NULL;
  4  END;
  5  /

Procedure created.

SQL>
SQL> CREATE OR REPLACE PROCEDURE ONEFIBER_LNK_MIGRATE_NLDC AS
  2  BEGIN
  3  NULL;
  4  END;
  5  /

Procedure created.

SQL>
SQL> CREATE OR REPLACE PROCEDURE PROC_MIGRATE_ONEIBER AS
  2  BEGIN
  3  ONEFIBER_LNK_MIGRATE;
  4  ONEFIBER_LNK_MIGRATE_CITY;
  5  ONEFIBER_LNK_MIGRATE_NLDC;
  6  END PROC_MIGRATE_ONEIBER;
  7  /

Procedure created.

SQL>

Upvotes: 1

Related Questions