OraFAQ Forum: Reports & Discoverer » Problem with Temporary table

Home » Developer & Programmer » Reports & Discoverer » Problem with Temporary table (Oracle Forms & Report 6i, Database 9i, Win Server 2003)

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

Problem with Temporary table [message #444524]

Mon, 22 February 2010 06:14

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

Report message to a moderator

Re: Problem with Temporary table [message #444525 is a reply to message #444524]

Mon, 22 February 2010 06:17

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use a non temporary table

Report message to a moderator

Re: Problem with Temporary table [message #444527 is a reply to message #444524]

Mon, 22 February 2010 06:20

ramoradba
Messages: 2456
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

Report message to a moderator

Re: Problem with Temporary table [message #444528 is a reply to message #444524]

Mon, 22 February 2010 06:24

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 ?

Report message to a moderator

Re: Problem with Temporary table [message #444529 is a reply to message #444528]

Mon, 22 February 2010 06:26

ramoradba
Messages: 2456
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

Report message to a moderator

Re: Problem with Temporary table [message #444541 is a reply to message #444524]

Mon, 22 February 2010 07:29

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

Report message to a moderator

Re: Problem with Temporary table [message #444602 is a reply to message #444524]

Mon, 22 February 2010 23:15

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.

Report message to a moderator

Re: Problem with Temporary table [message #444647 is a reply to message #444524]

Tue, 23 February 2010 03:50

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

Report message to a moderator

Previous Topic:	Discoverer reports with a particular item
Next Topic:	REP-1401 and rep-0619

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 22:12:23 CDT 2024