Hello,
I'm trying to get the schema name, instance name, and record count per page on my report.
I figured out how to get the schema and instance name on individual reports using a placeholder column and the before report trigger:
function BeforeReport return boolean is
begin
select sys_context('userenv', 'current_schema')
into :cp_schema_name from dual;
select INSTANCE_NAME
into :cp_instance_name from v$instance;
return (TRUE);
end;
Now I have schema and instance name at the bottom of every page of the report.
I can't figure out how to do this same thing through a oracle report template.
[Updated on: Tue, 15 December 2015 10:09]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
