OraFAQ Forum: Forms » how to create global pl/sql table in form

Home » Developer & Programmer » Forms » how to create global pl/sql table in form

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

how to create global pl/sql table in form [message #387636]

Fri, 20 February 2009 02:54

drajeshonline
Messages: 11
Registered: February 2009

Junior Member

Hi Everybody,

I need help on creating PL/SQL table so that i can retain the table value for the entire session,..

Thanks in advance,.

Report message to a moderator

Re: how to create global pl/sql table in form [message #387658 is a reply to message #387636]

Fri, 20 February 2009 03:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you consider using a global temporary table?

Report message to a moderator

Re: how to create global pl/sql table in form [message #387666 is a reply to message #387658]

Fri, 20 February 2009 04:08

drajeshonline
Messages: 11
Registered: February 2009

Junior Member

can you please tell me how to achive using GTT,....

Report message to a moderator

Re: how to create global pl/sql table in form [message #387671 is a reply to message #387636]

Fri, 20 February 2009 04:19

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

Senior Member

Achieve what?

You create a global temp table, you insert data into it, you query data back out, data exists for life of session.

Read up on global temporary tables in the documentation.

Report message to a moderator

Previous Topic:	excel to forms
Next Topic:	How to stop inserting new record in tabular form based on specific condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 11:23:07 CST 2025