Home » Developer & Programmer » Reports & Discoverer » Problem with Temporary table (Oracle Forms & Report 6i, Database 9i, Win Server 2003)
Problem with Temporary table [message #444524] Mon, 22 February 2010 06:14 Go to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

Hi friends.
I have a problem with temporary table.
I have created a temporary table (on commit preserve data).

I am inserting data from my Form into temporary table, and i have created report with that temporary table to display data.

when i execute report , there is no any data displays in report.
but data still exist in form.

i know that the data will preserve only for current session , and report will create new session thats why i cant see the data in it.

But i want to know if any other way to display that records from temporary table ?


- Pinkal



Re: Problem with Temporary table [message #444525 is a reply to message #444524] Mon, 22 February 2010 06:17 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use a non temporary table
Re: Problem with Temporary table [message #444527 is a reply to message #444524] Mon, 22 February 2010 06:20 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
But i want to know if any other way to display that records from temporary table ?


No such way to do.Only thing is use Non temporary as suggested already..
sriram Smile
Re: Problem with Temporary table [message #444528 is a reply to message #444524] Mon, 22 February 2010 06:24 Go to previous messageGo to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

can i call the report as a same session of current form's session ?
Re: Problem with Temporary table [message #444529 is a reply to message #444528] Mon, 22 February 2010 06:26 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I did n`t find such requirement or such feature.
So .."No" from my side.

sriram Smile
Re: Problem with Temporary table [message #444541 is a reply to message #444524] Mon, 22 February 2010 07:29 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd be very suprised if you can run them in the same session, they're different programs run through different interfaces (forms server and reports server). That pretty much makes seperate sessions mandatory.

One thing you might be able to do:
If you can move the logic that populates the temp table into a stored procedure then you can probably call that from the before report trigger. Just pass the parameters you'd pass to the stored procedure to the report so it can call it.
Re: Problem with Temporary table [message #444602 is a reply to message #444524] Mon, 22 February 2010 23:15 Go to previous messageGo to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

Thanks buddy
but right now i am doing exactly what you said but difference is that i am not using stored procedure , i had pass the data parameter from form to report , in this situation i can get the report what i want. but, i want to direct access that temporary table from report.

because there is lots of calculations and user inputs in form. so there is not possible to pass the all as parameter.
hence i had temporary done as passing a final result as parameter to the report.
Re: Problem with Temporary table [message #444647 is a reply to message #444524] Tue, 23 February 2010 03:50 Go to previous message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
In that case you're going to have to insert the data into a non-temporary table and then pass an id that identifies the rows you've inserted to the report so it can query them.
Previous Topic: Discoverer reports with a particular item
Next Topic: REP-1401 and rep-0619
Goto Forum:
  


Current Time: Mon Dec 05 21:18:22 CST 2016

Total time taken to generate the page: 0.05336 seconds