PL/SQL (MOSC)

MOSC Banner

How to define an executable to use a package?

edited Jul 14, 2015 12:09PM in PL/SQL (MOSC) 10 commentsAnswered ✓

Hi there,

New in create package and its usage.  Here is the situation I got:

-  I create a package with a series of procedures in it and compile it without problem.  Let's call it NNN.

-  I need to use it in a concurrent process, so I define an executable with execution method = PL/SQL Stored Procedue

-  However, when I tried to choose executable file name and I couldn't find my package and there is no LOV there.

-  I entered my package name, NNN in executable file name field and system allowed me to save.

-  When I run the concurrent process, it ends with error: PLS-00221: 'NNN' is not a procedure or is undefined

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