Home » Developer & Programmer » Forms » Oracle Report is not using same session (Oracle forms 10g,Oracle 7 database, Win 7 )
Oracle Report is not using same session [message #650137] Sun, 17 April 2016 03:00 Go to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi All

I appreciate if someone help me out.
I posted few records in oracle form by using post command without using commit and now I want to see those changes by using oracle report but the problem is that when I try to call/open oracle report by using oracle form then report is opening in a new session and I cant see my posted changes, can anyone suggest me how to solve this problem. Thanks in advance
Re: Oracle Report is not using same session [message #650167 is a reply to message #650137] Mon, 18 April 2016 02:32 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't believe it's possible to have them in the same session. Since they are separate programs each has to maintain its own session.
Re: Oracle Report is not using same session [message #650220 is a reply to message #650167] Tue, 19 April 2016 14:49 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Thanks for the reply, is there any way through which I can loop through all screen and put it into collection and then pass that collection to pipeline function and use that function to generate report... or any other way to save posted data on screen and generate report through that...
Re: Oracle Report is not using same session [message #650224 is a reply to message #650220] Wed, 20 April 2016 02:54 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Not that I know of - I don't believe reports can accept array type parameters which is what you would need.
You have to either pass every bit of data as individual parameters - which really isn't workable for a multi-row report - or commit the data.
Re: Oracle Report is not using same session [message #650462 is a reply to message #650137] Mon, 25 April 2016 16:12 Go to previous messageGo to next message
bluetooth420
Messages: 146
Registered: November 2011
Senior Member
why not to store it in temporary table and then make report from the temporary table
Re: Oracle Report is not using same session [message #650468 is a reply to message #650462] Tue, 26 April 2016 03:24 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Because temporary tables are session specific and reports has to run in a different session to forms.
Re: Oracle Report is not using same session [message #650563 is a reply to message #650137] Wed, 27 April 2016 11:21 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Thanks for the replies, actually I use temporary tables and now its working fine. Thanks
Re: Oracle Report is not using same session [message #650572 is a reply to message #650563] Wed, 27 April 2016 14:39 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe CM (as well as I) was thinking of global temporary tables, which wouldn't work in this context.
Re: Oracle Report is not using same session [message #650573 is a reply to message #650572] Wed, 27 April 2016 14:44 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Actually I don't use global temporary table, I use regular table to store session level data. Thanks
Re: Oracle Report is not using same session [message #650606 is a reply to message #650137] Thu, 28 April 2016 05:37 Go to previous message
bluetooth420
Messages: 146
Registered: November 2011
Senior Member
Mine was just a suggestion.

it was just hit and trial from my side.


cookiemonster and Littlefoot are my respected seniors.





Previous Topic: FRM-41213 unable to connect to the report server
Next Topic: progress bar(necessary)
Goto Forum:
  


Current Time: Thu Mar 28 17:28:51 CDT 2024