OraFAQ Forum: Reports & Discoverer

Wed, 23 June 2010 01:10

ashokb21
Messages: 92
Registered: May 2010

Member

function BeforeReport return boolean is
begin
  mo_global.SET_POLICY_CONTEXT('S',82);
  return (TRUE);
end;

[Updated on: Wed, 23 June 2010 01:12]

Wed, 23 June 2010 01:12

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

??? fucntion What Next ..what is the problem ?

Wed, 23 June 2010 01:13

ashokb21
Messages: 92
Registered: May 2010

Member

hi i want to set my organization_id on report level the above give code is showin error as (mo_global.SET_POLICY_CONTEXT) must be declare.

Wed, 23 June 2010 01:14

ashokb21
Messages: 92
Registered: May 2010

Member

mo_global.SET_POLICY_CONTEXT this a standard package to set organization_id

[Updated on: Wed, 23 June 2010 02:26]

Wed, 23 June 2010 03:51

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then presumably whatever user you are connected to reports as doesn't have execute permission on the package.

Previous Topic:	ignoring null values
Next Topic:	During open my report the discoverer application frozen

Goto Forum:

]

Current Time: Wed Apr 24 22:51:15 CDT 2024