Home » Applications » Oracle Fusion Apps & E-Business Suite » Running a sql package via a concurrent request
Running a sql package via a concurrent request [message #174819] Tue, 30 May 2006 12:16 Go to next message
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 Go to previous messageGo to next message
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?
Re: Running a sql package via a concurrent request [message #174826 is a reply to message #174823] Tue, 30 May 2006 12:46 Go to previous messageGo to next message
rbertrand
Messages: 45
Registered: November 2005
Member
yes, that makes perfect sense. Thanks for the help Art!!
Re: Running a sql package via a concurrent request [message #174859 is a reply to message #174826] Tue, 30 May 2006 16:41 Go to previous message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Art,
Will you create a package owned by scott ?
Will that work if the procedure reads standards tables ?
Previous Topic: eBS define flexfields
Next Topic: Errer when running Funds Check Process
Goto Forum:
  


Current Time: Sun May 19 05:58:29 CDT 2024