Home » Developer & Programmer » Reports & Discoverer » Pl/Sql function
Pl/Sql function [message #462150] Wed, 23 June 2010 01:10 Go to next message
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]

Report message to a moderator

Re: Pl/Sql function [message #462151 is a reply to message #462150] Wed, 23 June 2010 01:12 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
??? fucntion What Next ..what is the problem ?
Re: Pl/Sql function [message #462152 is a reply to message #462150] Wed, 23 June 2010 01:13 Go to previous messageGo to next message
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.
REPORT [message #462153 is a reply to message #462152] Wed, 23 June 2010 01:14 Go to previous messageGo to next message
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]

Report message to a moderator

Re: REPORT [message #462212 is a reply to message #462153] Wed, 23 June 2010 03:51 Go to previous message
cookiemonster
Messages: 13894
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: Fri May 29 15:53:12 CDT 2020