Running a sql package via a concurrent request [message #174819] |
Tue, 30 May 2006 12:16  |
rbertrand
Messages: 45 Registered: November 2005
|
Member |
|
|
Hello,
I have a stored package that we currently run using pl/sql script. I would like to set it up to run via concurrent program. I have setup many procedures to run using concurrent program, but never a package. Is it possible, and if so, can you direct me to setup info?
Thanks in advance!
|
|
|
Re: Running a sql package via a concurrent request [message #174823 is a reply to message #174819] |
Tue, 30 May 2006 12:35   |
Art Metzer
Messages: 2480 Registered: December 2002
|
Senior Member |
|
|
Well, you don't exactly "run a package": you will still run a procedure that just so happens to be contained within a package.
On the Concurrent Program Executable screen, then, your Executable Method will still be "PL/SQL Procedure", but your Executable File Name, instead of being SCOTT.PROCEDURE_NAME will be SCOTT.PACKAGE_NAME.PROCEDURE_NAME.
Does that make sense?
|
|
|
|
|