api_application.getid returns unexpected value

The function API_APPLICATION.GETID seems to return the value of T_BDF_APPLICATIONSESSION.BDF_APPLICATIONSESSION_OID, where I would expect the value of T_BDF_APPLICATION.BDF_APPLICATION_OID. Is this correct behaviour?

And if so, is there another function that returns the oid of the current application?

api_application

asked 28 Sep '12, 05:53

Peter W
121●9
accept rate: 0%

2 Answers:

oldest newest most voted

0	Hi Peter, All APIs always return run-time values of the object. That's why it returns the bdf_applicationsession_oid. We currently do not have API to get current application id. Regards link answered 28 Sep '12, 06:39 Samet Basaran 137●2 accept rate: 24%

Hi peter, you can use a function like this : function getApplicationID(pSessionID in number := null) return number is fAppID number; begin select bdf_application_oid into fAppID from formspider.t_bdf_applicationsession where bdf_applicationsession_oid = nvl(pSessionID, api_application.getID); return fAppID; exception when OTHERS then return null; end;

Don't forget to add the correct grants to the calling user. I usualy "grant select any table".

Regards

link

answered 28 Sep '12, 06:52

Vlisidis Akis
163●2●23
accept rate: 5%

edited 28 Sep '12, 10:31

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

api_application ×7