Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    3

    Unanswered: Need help on Global Temp Table

    Hi All,

    I need help on GTT. I need to create a table and hold few values and pass across different procedures for each user login separately.

    I am creating GTT in one procedure and using the same in another procedure and inside a trigger. When i am trying to get the values from trigger it says no records to find. Is session specific to application or database. how it is working. Please help me.

    Thanks
    Sri

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    when all else fails Read The Fine Manual

    Managing Tables

    In some/many/most cases Temporary Table is not need in Oracle
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    In some/many/most cases Temporary Table is not need in Oracle

    I have always thought they were lazy person's way of writing code/SQL. Aside from their original intent, bringing non-database elements in to join to the database.
    Dave

  4. #4
    Join Date
    Jun 2010
    Posts
    3
    Thanks for all your help

Posting Permissions

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