|
|
|
Re: tried to execute the below code. Its run but not getting expected output [message #674649 is a reply to message #674636] |
Wed, 06 February 2019 14:00 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Hriday2289 wrote on Wed, 06 February 2019 16:20It's related with oracle only .. oracle concurrent program.. in Applications Developer responsibility->Concurrent-->define
I do not know your application, however this description looks like a selection from menu.
I know some web applications; (nearly) all of them have section "Help" on the right or bottom side. You should visit it. I bet it contains more information about that functionality than you posted here.
|
|
|
|
|
|
|
|
|
|
Re: tried to execute the below code. Its run but not getting expected output [message #674677 is a reply to message #674674] |
Fri, 08 February 2019 10:13 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Hriday2289 wrote on Fri, 08 February 2019 14:56http://oracleappsinfo-r12.blogspot.com/2015/01/steps-to-create-concurrent-program.html
I gone through the given above URL for creation of concurrent request with plsql stored procedure and I already followed each and every steps but still not get result.
Hm, but you are aware that this was quite impossible to deduce from your posts? Even now I wonder what you exactly did.
I wonder what your complaint "logs not generated" meant. Anyway, as the procedure does not call any transaction end (COMMIT or ROLLBACK statement), the changes may be lost in the dedicated session end.
This is just a guess as I have no idea what "locator not created" means and how your sqlplus session (SHOW AUTOCOMMIT) and "concurrent request run" (as the sample code in the link just displays data) are configured.
|
|
|
|
Re: tried to execute the below code. Its run but not getting expected output [message #674697 is a reply to message #674679] |
Mon, 11 February 2019 06:50 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Hriday2289 wrote on Sat, 09 February 2019 06:01Yes, my procedure is working when I run through the Oracle Sql Developer and it creates the locator into expected table also generates the logs that I mentioned into the code. But the same is from concurrent request it not gives me output, if i recompile the procedure from Oracle Sql Developer and again run the concurrent request then it works. I need the result on concurrent request run, no need to recompile the procedure from sql developer.
I hope you had a good weekend. So, now, sit down, have a coffee and re-read your posts. Do you think the last one clearly describes your problem?
If so, please point me to the part describing what "recompile" exactly means.
It would be also nice if you explained how did you come to an idea about this action (whatever it covers) being helpful.
I am out of ideas so I cannot recommend you anything.
Additionally, if you expect to see the content of DBMS_OUTPUT.PUT_LINE in output screen (displayed by "View Output" button), you are probably out of luck, as
Quote:From a quick look to the program in the beginning it seems that FND_FILE.PUT_LINE is used to put rows to Output (see sample at the bottom).
(however, you should already be aware of that, as you followed each and every steps of that article)
|
|
|
Re: tried to execute the below code. Its run but not getting expected output [message #674971 is a reply to message #674679] |
Tue, 26 February 2019 11:16 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
@Hriday2289: Any new tool used? Any feedback?
Although I do not like guessing, here is my assumption of the current status:
The procedure ran smoothly when invoked as concurrent program - at least after committing its transaction in the procedure end.
Maybe you was confused when not seeing content of DBMS_OUTPUT buffer in Output screen (via "View Output" button). Hm.
However, I still wonder which action is called "recompile". Those ten pair of hard coded values have constant values, although meanwhile their amount dropped to 9, correct?
|
|
|