Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched
Search how an named "PROCEDURE MAIN(pOutputTraceFlag VARCHAR2 DEFAULT 'N');" is launched [message #657164] Fri, 28 October 2016 11:44 Go to next message
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

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Yesterday !
But i have roolback and problem still persit !
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So something is still different.

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 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
PL/SQL don't launch automatically procedure called MAIN ????
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 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
I have rollback package ? what else could be different ?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Something you or something else changed.

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 Go to previous messageGo to next message
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 !!
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 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
You confirm me Oralce dont' start prcedure named MAIN ?
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 Go to previous messageGo to next message
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 ?
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 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
REGLE, fichu scheduleur !!!!
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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)?
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 Go to previous message
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

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


Current Time: Thu Mar 28 09:34:01 CDT 2024