Home » Applications » Oracle Fusion Apps & E-Business Suite » PL/SQL Loop Run Concurrently (merged) (Oracle EBS 12,Windows 7)
PL/SQL Loop Run Concurrently (merged) [message #663998] Sun, 02 July 2017 20:22 Go to next message
Ryuki
Messages: 6
Registered: July 2017
Junior Member
Hi,

I was create SQL procedure for send automatic email with attachment pdf file from concurrently output.
It's work with 1 input parameter, 1 output page, 1 file and 1 destination email.*(later let's call this procedure A).

But, i have a problem when i input more than 1 parameter on concurrently it's mean i have some output page on 1 file pdf.
Because every single parameter have a unique output page and unique destination email,
so i can't put some output page on 1 file pdf as attachment to destination email.

i have an idea to create new procedure to make (procedure A) loop with more than 1 parameter input.
but how to do this ?, is that possible ?

Thanks for every help.
Re: PL/SQL Loop Run Concurrently [message #663999 is a reply to message #663998] Sun, 02 July 2017 22:28 Go to previous messageGo to next message
BlackSwan
Messages: 25715
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: PL/SQL Loop Run Concurrently [message #664000 is a reply to message #663998] Mon, 03 July 2017 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
But, i have a problem when i input more than 1 parameter on concurrently it's mean i have some output page on 1 file pdf.
Because every single parameter have a unique output page and unique destination email,
so i can't put some output page on 1 file pdf as attachment to destination email.
This is completely meaningless for us.
Show your current code and explain us how you want to improve.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.


Re: PL/SQL Loop Run Concurrently [message #664002 is a reply to message #664000] Mon, 03 July 2017 01:41 Go to previous messageGo to next message
Ryuki
Messages: 6
Registered: July 2017
Junior Member
Michel Cadot wrote on Mon, 03 July 2017 01:02

Show your current code and explain us how you want to improve.
let me simplify my question.

"How to run concurrent from procedure and make it loop as many as parameter input on procedure ?"
Re: PL/SQL Loop Run Concurrently [message #664003 is a reply to message #664002] Mon, 03 July 2017 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
How to run concurrent from procedure
Use jobs.

Quote:
make it loop as many as parameter input on procedure
Use LOOP.

Re: PL/SQL Loop Run Concurrently [message #664007 is a reply to message #664003] Mon, 03 July 2017 03:16 Go to previous messageGo to next message
Ryuki
Messages: 6
Registered: July 2017
Junior Member
Michel Cadot wrote on Mon, 03 July 2017 01:45

Quote:
How to run concurrent from procedure
Use jobs.

Quote:
make it loop as many as parameter input on procedure
Use LOOP.

do you have an example code with loop a jobs ?
Re: PL/SQL Loop Run Concurrently [message #664011 is a reply to message #664007] Mon, 03 July 2017 06:40 Go to previous messageGo to next message
EdStevens
Messages: 848
Registered: September 2013
Senior Member
Ryuki wrote on Mon, 03 July 2017 03:16
Michel Cadot wrote on Mon, 03 July 2017 01:45

Quote:
How to run concurrent from procedure
Use jobs.

Quote:
make it loop as many as parameter input on procedure
Use LOOP.

do you have an example code with loop a jobs ?
Why are you so resistant to showing us the code you have already?
Can you "improve" code you cannot see?
No? Well, neither can anyone else.

We need to see what parameters you have now, how they are provided to the "existing" (but unknown to us) "procedure A", and what parameters would be come "multiple parameters".



Examples?
"for loop" https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/for_loop_statement.htm#LNPLS1536

jobs - https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_job.htm#ARPLS019

But as I think I understand your problem, you may not need jobs at all. Untill you are more forthcoming with details, we really can't say.
Registering PL/SQL Procedure on Concurrent [message #664173 is a reply to message #663998] Thu, 06 July 2017 04:38 Go to previous messageGo to next message
Ryuki
Messages: 6
Registered: July 2017
Junior Member
Hi,

I was create procedure for send some value into a table.
and its running well if i run the procedure from sql developer,
but i want to run the procedure from concurrent, so i registering the procedure on concurrent.

This is my step to register :

./fa/13574/0/

and i was give a grant and public synonim

this is my header procedure :

create or replace PROCEDURE SRI_TTDV_SEND
(errbuf  out varchar2,retcode out varchar2, P_TTDV_FROM IN NUMBER, P_TTDV_TO IN NUMBER, P_USER IN VARCHAR2) IS

And this is the Error Message :

Quote:
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'SRI_TTDV_SEND' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

am i miss some step ? or what to make this run?

Thanks for any help
Re: PL/SQL Loop Run Concurrently [message #664174 is a reply to message #664011] Thu, 06 July 2017 04:48 Go to previous messageGo to next message
Ryuki
Messages: 6
Registered: July 2017
Junior Member
EdStevens wrote on Mon, 03 July 2017 06:40

Why are you so resistant to showing us the code you have already?
Can you "improve" code you cannot see?
No? Well, neither can anyone else.

We need to see what parameters you have now, how they are provided to the "existing" (but unknown to us) "procedure A", and what parameters would be come "multiple parameters".

But as I think I understand your problem, you may not need jobs at all. Untill you are more forthcoming with details, we really can't say.
sorry, i'm not resistant but i just use some difference procedure and linux command, so i think i dont need to put on this topic cause it was work fine and i just need to place loop and job code.

but thanks for your answer, i'm really appreciate that.
Re: PL/SQL Loop Run Concurrently [message #664175 is a reply to message #664174] Thu, 06 July 2017 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But if we ask you it repeatedly this is because we need it and we don't understand why you don't want to post it if you want to be helped.

Re: PL/SQL Loop Run Concurrently [message #664176 is a reply to message #664175] Thu, 06 July 2017 05:01 Go to previous messageGo to next message
Ryuki
Messages: 6
Registered: July 2017
Junior Member
Michel Cadot wrote on Thu, 06 July 2017 04:53

But if we ask you it repeatedly this is because we need it and we don't understand why you don't want to post it if you want to be helped.

ok, i got it.
but i was move to another topic and forget the first one (i want to close it and on going to find close topic button) but it was merged.

i was send what i think is needed in the registering pl/sql procedure to concurrent topic, can you just focus on that topic.
Re: PL/SQL Loop Run Concurrently [message #664180 is a reply to message #664176] Thu, 06 July 2017 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think you are in the wrong forum.
It is not a PL/SQL question but an EBS one.
So I move your topic to this forum.

Re: PL/SQL Loop Run Concurrently [message #664212 is a reply to message #664180] Fri, 07 July 2017 01:30 Go to previous message
Alien
Messages: 274
Registered: June 1999
Senior Member
Your custom procedure should be installed under APPS, not the application owner (SRI)

Regards,

Arian
Previous Topic: How to pass parameters to ADF from EBS(Ex:User Id) (merged 3)
Next Topic: Auto schedule bundled email or request set
Goto Forum:
  


Current Time: Sun Nov 19 15:36:04 CST 2017

Total time taken to generate the page: 0.01225 seconds