OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » PL/SQL Loop Run Concurrently (merged)

Home » Applications » Oracle Fusion Apps & E-Business Suite » PL/SQL Loop Run Concurrently (merged) (Oracle EBS 12,Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL Loop Run Concurrently (merged) [message #663998]

Sun, 02 July 2017 20:22

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #663999 is a reply to message #663998]

Sun, 02 July 2017 22:28

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664000 is a reply to message #663998]

Mon, 03 July 2017 01:02

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664002 is a reply to message #664000]

Mon, 03 July 2017 01:41

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 ?"

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664003 is a reply to message #664002]

Mon, 03 July 2017 01:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664007 is a reply to message #664003]

Mon, 03 July 2017 03:16

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 ?

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664011 is a reply to message #664007]

Mon, 03 July 2017 06:40

EdStevens
Messages: 1376
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.

Report message to a moderator

Registering PL/SQL Procedure on Concurrent [message #664173 is a reply to message #663998]

Thu, 06 July 2017 04:38

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 :

/forum/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

Attachment: ttdv concurrent.png
(Size: 44.82KB, Downloaded 3472 times)

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664174 is a reply to message #664011]

Thu, 06 July 2017 04:48

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664175 is a reply to message #664174]

Thu, 06 July 2017 04:53

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664176 is a reply to message #664175]

Thu, 06 July 2017 05:01

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664180 is a reply to message #664176]

Thu, 06 July 2017 05:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: PL/SQL Loop Run Concurrently [message #664212 is a reply to message #664180]

Fri, 07 July 2017 01:30

Alien
Messages: 292
Registered: June 1999

Senior Member

Your custom procedure should be installed under APPS, not the application owner (SRI)

Regards,

Arian

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:33:57 CST 2024