OraFAQ Forum: Reports & Discoverer » Running Reports from PL/SQL

Home » Developer & Programmer » Reports & Discoverer » Running Reports from PL/SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running Reports from PL/SQL [message #212290]

Thu, 04 January 2007 09:23

Aver
Messages: 29
Registered: December 2006

Junior Member

How can i run Reports from PL/SQL?

Report message to a moderator

Re: Running Reports from PL/SQL [message #212359 is a reply to message #212290]

Thu, 04 January 2007 21:00

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi Aver,

you can get the report type format in Sql.

Bye
Ashu

Report message to a moderator

Re: Running Reports from PL/SQL [message #212642 is a reply to message #212290]

Sun, 07 January 2007 01:20

Aver
Messages: 29
Registered: December 2006

Junior Member

I need to engage the Developer Reports from Table trigger.

Report message to a moderator

Re: Running Reports from PL/SQL [message #212650 is a reply to message #212642]

Sun, 07 January 2007 03:24

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you explain the problem a little bit more? Perhaps you only *think* that Report is a solution, but there might be something else available which would better suit your needs.

Oh, yes - I don't know how to run report from a database trigger.

Report message to a moderator

Re: Running Reports from PL/SQL [message #212652 is a reply to message #212290]

Sun, 07 January 2007 04:18

Aver
Messages: 29
Registered: December 2006

Junior Member

It's exactly the problem - to run report from a database trigger.

Report message to a moderator

Re: Running Reports from PL/SQL [message #212667 is a reply to message #212652]

Sun, 07 January 2007 07:35

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps Event-Driven Publishing is what you are looking for. Check an example in section 11-3: Invoking a Report From a Database Event.

Report message to a moderator

Re: Running Reports from PL/SQL [message #212730 is a reply to message #212290]

Mon, 08 January 2007 00:49

Aver
Messages: 29
Registered: December 2006

Junior Member

This require the API instalation of Oracle9iAS Reports Services Security and Oracle9iAS Portal.
I mean the commands like dbms_... that built-in in Oracle DB.

Report message to a moderator

Previous Topic:	REP-520005 error problem
Next Topic:	Interview questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 11:18:04 CDT 2024