Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Return multiple values in a function

user5108636Feb 9 2019 — edited Feb 25 2019

Hi All,

         I have a client requirement to write a  single function and return two values in two plsql variables. As per my analysis, I have two options to return to calling program these two variables. Define a type or return a system ref cursor.

Also cannot use a procedure

Client's justification is why this cannot be done in a procedure is the function needs to be called in the OBIEE queries as well. Type definition is also not preferred by the client either and cannot split the function call as well.

Wonder how I can return these two values in two variables using the system refcursor. Or is there a better alternative, please advise.

Thanks

Comments

asim cholas

Check in the below paths

Nqquerylog

OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

Nqserver log

OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1


If you couldnt find it here also check via EM


Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics-> Log Messages


Check this blog for further info..

a BI Developer's Journal: Log Files in OBIEE 11g


Thanks

Aj

1055274

Hi Aj,

Thanks for your reply.

Question is how can we see those log files if they are not getting generated in that path.

Thanks,

Kumar

asim cholas

As of my understanding, You can set it in NQSConfig.INI

asim cholas

In 11g check ine Enterprice manager's Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics->log Settings tab as well.

thanks
Aj

1055274

Hi AJ,

if you can help me where exactly i need to make changes that would be helpful.

Thanks,

Kumar

asim cholas

I do not have EM access to check that... Why don't you open your EM and Check??

1055274

In EM Also i can see the logs other than nqserver and nqquery logs.

i have clicked on presentation serverices log and server logs but i cant find these logs.

asim cholas

Enterprice manager's Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics->log Settings



did you check this tab??

1055274

Yes i have checked the log file in mentioned tabs in EM.

i have set it as Finest for the presentation server log and server log.

it will work now.

Thanks,

Kumar

1055274

Hi Friends,

Even after setting it as finest still i cant see the log files getting generated.

Am i missing something here?

Thanks,

Anand

asim cholas

Set loglevel manually in report and check whether it is generating query..

Thanks

Aj

1055274

Aj,

it will generate query no issues but i cant find these log files in BIserver Component under diagnostics.

Thanks,

Kumar

asim cholas

did you set some values for maximum log age, maximum log file size, Default log level(info) etc? all other settings should be default. Can you paste me the whole path where you are searching your log.... Did you try to view log from EM?

Business intelligence->Core application - > Diagnostics->Log messages.... What is happening when you try to view the log from EM??

1055274

under diagnostsics in EM i can see logs other than nqquery and nqserver logs.

instead of info i have set it finest thinking that would resolve my problem but that is not the case.

Thanks,

Kumar

1 - 15

Post Details

Added on Feb 9 2019
12 comments
7,602 views