Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to run a package through execute command in oracle pl sql

1043556Jun 2 2017 — edited Jun 2 2017

Hi all please advise

how to run a package through execute command in oracle pl sql, my package is having one out parameter.

EXECUTE PKG_LOD_PATCH.SP_LOD_RPT(null);

Getting error

below script is working fine.

DECLARE

W_ERRMSG VARCHAR2(1000);

BEGIN

PKG_LOD_PATCH.SP_LOD_RPT(W_ERRMSG);

END;

/

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2017
Added on Jun 2 2017
8 comments
24,278 views