OraFAQ Forum: Forms » Oracle Report is not using same session

Home » Developer & Programmer » Forms » Oracle Report is not using same session (Oracle forms 10g,Oracle 7 database, Win 7 )

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

Oracle Report is not using same session [message #650137]

Sun, 17 April 2016 03:00

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

Report message to a moderator

Re: Oracle Report is not using same session [message #650167 is a reply to message #650137]

Mon, 18 April 2016 02:32

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: Oracle Report is not using same session [message #650220 is a reply to message #650167]

Tue, 19 April 2016 14:49

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...

Report message to a moderator

Re: Oracle Report is not using same session [message #650224 is a reply to message #650220]

Wed, 20 April 2016 02:54

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: Oracle Report is not using same session [message #650462 is a reply to message #650137]

Mon, 25 April 2016 16:12

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

why not to store it in temporary table and then make report from the temporary table

Report message to a moderator

Re: Oracle Report is not using same session [message #650468 is a reply to message #650462]

Tue, 26 April 2016 03:24

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: Oracle Report is not using same session [message #650563 is a reply to message #650137]

Wed, 27 April 2016 11:21

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

Report message to a moderator

Re: Oracle Report is not using same session [message #650572 is a reply to message #650563]

Wed, 27 April 2016 14:39

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Oracle Report is not using same session [message #650573 is a reply to message #650572]

Wed, 27 April 2016 14:44

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

Report message to a moderator

Re: Oracle Report is not using same session [message #650606 is a reply to message #650137]

Thu, 28 April 2016 05:37

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 04:50:38 CST 2025