Hi all.
Currently working with Apex 4.2.
My requirement is to access query builder directly from Oracle Forms 11g using web_show.document.
Eventhough i know this is possible as long as you supply a valid url, have a few questions:
1) Normally a call to Apex is an URL that specifies an application to run, which must belong to a workspace. In the case you only want a user to just access Apex Query Builder, Do i still need an application?. If so why?
2) When you create an application you grant access to specific components based on roles: administrator, developer, end user, and so forth. In this scenario, which role should this user have?. Again, all what is needed for the moment is access to Query Builder.
3) Which table holds information related to user stored Apex Queries?
4) Finally, my application uses updateable join views and application context. How do i set application context in this situation? You know, after authentication, just before accessing QB?.
Help will be greatly appreciated ....!
Regards, Luis