Oracle Reports (MOSC)

MOSC Banner

Insert Report output data to Temp Table

edited February 2011 in Oracle Reports (MOSC) 1 commentAnswered
 Hi,

I am trying to insert Report output to one temp table but getting error

1. in after report triger i am writng insert statment

function AfterReport return boolean is
begin
 loop
  insert into test001(vendor_name)
  values (:description);
  end loop;
  commit;
  return (TRUE);
end;

but report is giving error "REP-1316: After Report Trigger references column 'DESCRIPTION' at wrong frequency.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1316: After Report Trigger references column 'DESCRIPTION' at wrong frequency"

please help.

Regards

Sushant

Howdy, Stranger!

Log In

To view full details, sign in.

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