Oracle Reports (MOSC)

MOSC Banner

Insert Report output data to Temp Table

edited Feb 2, 2011 4:01PM 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 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