OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched

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

Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657164]

Fri, 28 October 2016 11:44

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

Currently i have an PL/SQL Procedure in an package Named PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');
Since yesterday this procédure is not automatically Launched by ORACLE ?
I have rollback to all package an problem still persit ?
I have restart server too

Why ?

Regards

Phil

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657166 is a reply to message #657164]

Fri, 28 October 2016 11:49

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

Senior Member
Account Moderator

As BlackSwan often says: " When was last time this worked? What has changed since then? "

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657167 is a reply to message #657166]

Fri, 28 October 2016 11:51

pcouas
Messages: 112
Registered: February 2016

Senior Member

Yesterday !
But i have roolback and problem still persit !

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657168 is a reply to message #657167]

Fri, 28 October 2016 11:52

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

Senior Member
Account Moderator

So something is still different.

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657169 is a reply to message #657167]

Fri, 28 October 2016 11:52

pcouas
Messages: 112
Registered: February 2016

Senior Member

PL/SQL don't launch automatically procedure called MAIN ????

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657171 is a reply to message #657169]

Fri, 28 October 2016 11:53

pcouas
Messages: 112
Registered: February 2016

Senior Member

I have rollback package ? what else could be different ?

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657173 is a reply to message #657171]

Fri, 28 October 2016 11:59

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

Senior Member
Account Moderator

Something you or something else changed.

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657174 is a reply to message #657173]

Fri, 28 October 2016 12:02

pcouas
Messages: 112
Registered: February 2016

Senior Member

Yes but what ??
When i launch from SQLDEV
begin
DP_LO_DISPATCH_MAIL.MAIN('N');
end;

Procdure is running, i have search in all Packages an in APEX too and i don't found where this procédure is launched !!

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657175 is a reply to message #657174]

Fri, 28 October 2016 12:04

pcouas
Messages: 112
Registered: February 2016

Senior Member

You confirm me Oralce dont' start prcedure named MAIN ?

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657177 is a reply to message #657175]

Fri, 28 October 2016 13:12

pcouas
Messages: 112
Registered: February 2016

Senior Member

J'ai trouvé une partie du problem il y a plannificateur qui semble failure dans SqlDevlopper ?
Il lance la meme procédure que j'execute manuellement ?
Pourquoi est t'il failure maintenant ?

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657178 is a reply to message #657177]

Fri, 28 October 2016 13:18

pcouas
Messages: 112
Registered: February 2016

Senior Member

REGLE, fichu scheduleur !!!!

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657184 is a reply to message #657178]

Sat, 29 October 2016 10:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Please, use English language in main OraFAQ Forum. If you want to discuss something in French, you can do that - there's the French forum at the bottom of the main Forum page.

Anyway, I have NO IDEA what you are talking about.

pcouas

PL/SQL don't launch automatically procedure called MAIN ???? (...) You confirm me Oralce dont' start prcedure named MAIN ?

Why do you think that Oracle (yes, it is Oracle, not Oralce) automatically runs any procedure? Do you think that, if something is called "MAIN", runs just because?

As I said: nothing you said makes sense to me. Could you, please, explain it? Feel free to provide as many significant details as you want.

On the other hand, does your last message means that you found the culprit (i.e. the scheduler)?

Report message to a moderator

Re: Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657188 is a reply to message #657184]

Sun, 30 October 2016 04:22

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

I have resolved problem, i found an Scheduler in Oracle and i could see it in SQLDEVLOPPER.
MAIN procedure is launched by this SCHEDULER external from my Code.
IN French SQL DEVLOPPER -> Plannificateur -> Travaux SGBD -> 555 (id of apex APPLICATION) -> BROKEN Y
I have made BROKEN N and now that's OK

Regards

Report message to a moderator

Previous Topic:	How pass master region item values to Detail region items
Next Topic:	Dynamic SQL within SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 16:30:59 CDT 2025