Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Unanswered: Global temporary table data not show's in Report

    I am using Global temporary table "on commit preserve rows". I insert some data in to it and want to show that data on the report , when i generate report from that form the report shows nothing, But the data exists on that Temporary table, I think the problem is with session , as i know that the form and report have different session id's. What i should do now ?? i am using oracle Developer 6. Is there any way to show that data on my report. The report is generated from the same form.

  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    GTT's data may ONLY be viewed from the same session. Try using a recordset in forms, which can be passed
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    May 2010
    used session can do it ,I think!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts