OraFAQ Forum: Forms » Check database name

Home » Developer & Programmer » Forms » Check database name

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

Check database name [message #129086]

Thu, 21 July 2005 22:39

bluebeta
Messages: 14
Registered: June 2005

Junior Member

Hi,

I have a old oracle application source code which coding with oracle forms 4.5, but I use oracle form 6i to open it. Can any one tell me how to check the database name in this situation? this is because this application use more than one database.

Thank in advances.

Best regards
Andrene

Report message to a moderator

Re: Check database name [message #129357 is a reply to message #129086]

Sun, 24 July 2005 18:52

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

There are numerous ways to determine to which database you are connected. For example, get_application_property(connect_string) or NAME in v$database. If you want to know the version of the database then look in v$version.

David

Report message to a moderator

Re: Check database name [message #129363 is a reply to message #129357]

Sun, 24 July 2005 20:04

bluebeta
Messages: 14
Registered: June 2005

Junior Member

Hi,

Thanks for your reply.

But the problem is I do not have the database in my site. The thing that I have is just the source code only. That means I cannot run the application.

So, Can I check the database name that the application use through the okracle form.

Thank you.

Best regards
Andrene

Report message to a moderator

Re: Check database name [message #129370 is a reply to message #129363]

Sun, 24 July 2005 20:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You can get the table name by looking at the block's 'Base Table', and you can determine (some) of its columns by finding the items that have 'Base Table Item' defined as 'True'.

David

Report message to a moderator

Previous Topic:	Creating alert in forms 9i
Next Topic:	forms builder : urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:25:10 CDT 2024