OraFAQ Forum: Forms » database name in foms 6i

Home » Developer & Programmer » Forms » database name in foms 6i

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

database name in foms 6i [message #258106]

Fri, 10 August 2007 04:44

rishi1979
Messages: 36
Registered: November 2006

Member

How can i get the database name through oracle form 6i .
SYS_CONTEXT is not supported in forms 6i.if i write it in forms then it says sys_context must be declared.but it is working in oracle sql.plz help

thanks in advance

Report message to a moderator

Re: database name in foms 6i [message #258141 is a reply to message #258106]

Fri, 10 August 2007 06:55

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

Senior Member
Account Moderator

Write a stored function (i.e. the one which resides in the database) which would return information you need.

CREATE OR REPLACE FUNCTION my_context RETURN CHAR IS
BEGIN
  RETURN sys_context('USERENV', 'DB_NAME');
END;

Call this function from the form as

-- WHEN-NEW-FORM-INSTANCE trigger

:control.db_name := my_context;

Report message to a moderator

Re: database name in foms 6i [message #258172 is a reply to message #258141]

Fri, 10 August 2007 08:12

rishi1979
Messages: 36
Registered: November 2006

Member

Thanks for this but i want to know if there is any built which i can use in forms

Report message to a moderator

Re: database name in foms 6i [message #258239 is a reply to message #258172]

Fri, 10 August 2007 11:55

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

Senior Member
Account Moderator

Not in Forms 6i (as far as I can tell); SYS_CONTEXT was introduced in Oracle 8i, while Forms 6i are based on 8.0.6.

So, you can either use suggested database function or upgrade Forms to higher version (but be warned! 6i is the last client-server version!).

Report message to a moderator