OraFAQ Forum: Forms » get the name of de current table in Oracle Forms 6i

Home » Developer & Programmer » Forms » get the name of de current table in Oracle Forms 6i

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

get the name of de current table in Oracle Forms 6i [message #79855]

Thu, 18 July 2002 08:19

Dannyr
Messages: 2
Registered: July 2002

Junior Member

Hi. Would you help me please guys?.how can i get the name of the current table that i'm using? as i do with(for example) the username. The thing is, i need to assign the name of the table to a parameter in order to do something into a procedure. I already try with "SYSTEM.CURRENT_TABLE" but it doesn't works. Please help me, Thanks.

Report message to a moderator

Re: get the name of de current table in Oracle Forms 6i [message #79879 is a reply to message #79855]

Sat, 20 July 2002 04:49

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi,
do u have a Unique Column name in your table ?
i mean that column name is never repeated in any other table...in that case u have a solution...that is

select table_name into x from user_tab_columns where column_name= '<your unique column name in that table';

check it out
sai

Report message to a moderator

Previous Topic:	Reg procedures
Next Topic:	Re: How to set the Label of a Display item (Text Label)Programmatically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:15:34 CDT 2024