OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Change application name dynamically

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Change application name dynamically (Apex4.0,Oracle 10g,Win7 32 bit)

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

Change application name dynamically [message #617603]

Wed, 02 July 2014 04:17

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Hello,
I have one function that return the version number like "1.2" and version number is populated with the name of application like
when i edit the application so...
********-------------**********
Name - Maintenance_system_1.1
version -release 1.1
*******----------*************

but now i want to change the version number with the help of function ...
----function body-----------
return 1.2;
-------------------

So it'll reflect on Name filed and Version filed of application and home page of app...how can i do it....

Thanks,
Xandot

Report message to a moderator

Re: Change application name dynamically [message #617650 is a reply to message #617603]

Wed, 02 July 2014 09:24

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

Senior Member
Account Moderator

I don't know. But I'd remove release number from the name. So:
- name: Maintenance system
- release: 1.1

Report message to a moderator

Re: Change application name dynamically [message #617667 is a reply to message #617603]

Wed, 02 July 2014 10:39

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

How does your existing function retrieves the version?

Report message to a moderator

Re: Change application name dynamically [message #617721 is a reply to message #617667]

Thu, 03 July 2014 01:15

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Function :-
create or replace function get_version return number
as
begin
return 1.2 ;
end;
*************-----------------***********

The above one is the function that used for retrieving the version number and i want to change the application name dynamically
like now my application name is "Maintenance_system_1.1" but i want to change it like "Maintenance_system_<get_version>"
(it means "Maintenance_system_1.2" )

Thanks,
Xandot

[Updated on: Thu, 03 July 2014 01:15]

Report message to a moderator

Re: Change application name dynamically [message #617722 is a reply to message #617721]

Thu, 03 July 2014 01:31

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

SQL> SELECT 'Maintenance_system_'||get_version APPLICATION_NAME FROM dual;
APPLICATION_NAME
-----------------------------------------------------------
Maintenance_system_1.2

Report message to a moderator

Re: Change application name dynamically [message #617726 is a reply to message #617722]

Thu, 03 July 2014 01:46

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

But its not working in application name filed ....

Report message to a moderator

Re: Change application name dynamically [message #617746 is a reply to message #617726]

Thu, 03 July 2014 05:45

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Xandot wrote on Thu, 03 July 2014 12:16

But its not working in application name filed ....

That's not a proper explanation of what issue you are facing. Please elaborate.

Report message to a moderator

Re: Change application name dynamically [message #617757 is a reply to message #617746]

Thu, 03 July 2014 06:36

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Right now my application name is "Maintenance_system_1.1" , here 1.1 shows the version number but now the application has altered so the version number should be "1.2"
and the application name should be "Maintenance_system_1.2".

In future if any other alteration will happen then the version number should increase by 1.3 ...for the version number i have created the function as per the above post
that will reflect the new version number in all regions of my application except the name of application name..

So how can i change my application name dynamically like "Maintenance_system_1.1" ==To=>>> "Maintenance_system_1.2" ....

Thanks,
Xandot

[Updated on: Thu, 03 July 2014 06:37]

Report message to a moderator

Re: Change application name dynamically [message #617759 is a reply to message #617757]

Thu, 03 July 2014 07:00

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

How is the "application name alongwith version appended to it" is being populated now? To make it change dynamically with version, you need to pass the version number from whatever source it is coming from.

Any when you say that the query which I gave did not work, what exactly happened?

Report message to a moderator

Re: Change application name dynamically [message #617821 is a reply to message #617759]

Thu, 03 July 2014 15:10

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

Senior Member
Account Moderator

Xandot, repeating what you already said doesn't make things any clearer.

How do you get the application name now? Is it by using APP_ALIAS built-in substitution string? Or, do you get it from your own function?

If the former, you can't modify it. If the latter, adjust the function so that it returns both name and version.

Either way, you'll end up with a custom built function. Furthermore, it means that you might need to modify all the pages or a template (if possible & if you know how).

Report message to a moderator

Re: Change application name dynamically [message #617876 is a reply to message #617821]

Fri, 04 July 2014 03:16

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

Senior Member
Account Moderator

On a second (third, ...) thought, template has nothing to do with it.

If you chose to display app. name & version on every page, I'd suggest you to remove these fields from all pages, place them onto the page 0 and display these page 0 fields on all pages. Doing so, you'd populate them only once (with your own functions) and that would do it, I suppose.

Report message to a moderator

Re: Change application name dynamically [message #617894 is a reply to message #617876]

Fri, 04 July 2014 04:51

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Thanks Littlefoot and Lalit.....

Yup.. with the help of zero page i have achieved my goal....

Report message to a moderator

Previous Topic:	Add Text at end of the field
Next Topic:	Need to find login and logout information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 02:13:05 CDT 2024