CODEWITHSUNDEEP
oracle-databasestored-procedurespackage
Sai Avinash
Sai Avinash

Reputation: 4753

How to execute a procedure inside a package in oracle

I have seen some answers related to this question. But, my issue is not yet resolved.

I have 3 stored procs in my oracle package.

I am trying to execute a single porcedure, but i guess entire package is getting executed.

The syntax i am using :

Stored Proc with no input or output params

DECLARE
BEGIN
PackageName.Sp1;
END;

Some one , please help me where i am going wrong ?

Upvotes: 1

Views: 9379

Answers (1)

Rahul
Rahul

Reputation: 77846

Just execute it like below. Take out the DECLARE part since there is no parameter needs to be declared. 

BEGIN
PackageName.Sp1;
END;

Upvotes: 1

Related Questions