Database Administration (MOSC)

MOSC Banner

Creating environmental setting in discoverer

edited Nov 13, 2008 12:54AM in Database Administration (MOSC) 1 commentAnswered
Hi

I need to replicate a report that needs to be run via discoverer which can be run through SQL Plus.

An sql script can be run via SQL Plus with reults returned. However by runing it via SQL plus, the following needs to be set:

 exec dbms_application_info.set_client_info(your organization id);

I believe this is a environmental setting that can only be done via SQL plus? Is it possible to replicate this to allow the report to be run in discoverer?

Thanks

Manny

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center