OraFAQ Forum: Reports & Discoverer » How to create a report with package

Home » Developer & Programmer » Reports & Discoverer » How to create a report with package (Report 6i)

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

How to create a report with package [message #395057]

Tue, 31 March 2009 03:55

sajidrazmi
Messages: 47
Registered: August 2008
Location: oman

Member

Hi Dear All
I Have one package and i want to create a report on this particular package so please let me know how to create a report With package.
Thanks And Regards
Sajid

Report message to a moderator

Re: How to create a report with package [message #395512 is a reply to message #395057]

Wed, 01 April 2009 12:53

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

Senior Member
Account Moderator

Where would you want to use this package? In a report so that you could use its procedures? You can do that even if the package is stored in the database.

If not, what then?

Report message to a moderator

Re: How to create a report with package [message #396122 is a reply to message #395512]

Sat, 04 April 2009 01:33

sajidrazmi
Messages: 47
Registered: August 2008
Location: oman

Member

Hi Dear,
I Have created one package in database in package there are Function and Procedure I want To develope a report For Only This Procedure PEND_DOC_QUERY
And Package Name is (Asg_Stock_age).
I am sending You package Body,So please tell me how I have to use In Report.
Thanks and regards

Attachment: ASG_STOCK_AGE.pkb
(Size: 12.76KB, Downloaded 1148 times)

[Updated on: Sat, 04 April 2009 01:33]

Report message to a moderator

Re: How to create a report with package [message #396123 is a reply to message #396122]

Sat, 04 April 2009 01:36

sajidrazmi
Messages: 47
Registered: August 2008
Location: oman

Member

And This Specification

Attachment: ASG_STOCK_AGE.pks
(Size: 1.81KB, Downloaded 1132 times)

Report message to a moderator

Re: How to create a report with package [message #396162 is a reply to message #395057]

Sat, 04 April 2009 07:49

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

All the instructions can be found in report builder help. Just search it for ref cursor.

If you a have specific problem getting it to work let us know and we'll try and help you out.

Report message to a moderator

Re: How to create a report with package [message #396207 is a reply to message #396162]

Sat, 04 April 2009 23:46

sajidrazmi
Messages: 47
Registered: August 2008
Location: oman

Member

Hi Dear,
Thanks Allot For giving me response But i have allready tried by Ref Cursor. But it is giving me Error (Rep-0065 Virtual Memory System Error ) This Error Is Coming When i am Going to run The Report.
Please Let me know .

Thanks
Sajid

[Updated on: Sat, 04 April 2009 23:48]

Report message to a moderator

Re: How to create a report with package [message #396348 is a reply to message #395057]

Mon, 06 April 2009 04:38

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you seen this thread?
http://forums.oracle.com/forums/thread.jspa?threadID=186012

Report message to a moderator

Re: How to create a report with package [message #396516 is a reply to message #396348]

Tue, 07 April 2009 01:26

sajidrazmi
Messages: 47
Registered: August 2008
Location: oman

Member

Hi Dear,
Thanks, But I Have Already Checked that Forum but Still the Same Problem is happening.

Report message to a moderator

Re: How to create a report with package [message #396567 is a reply to message #395057]

Tue, 07 April 2009 04:07

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well I've never seen that error before. Unless someone else has some ideas I suggest you try metalink. Failing that avoid using ref cursors.

Report message to a moderator

Previous Topic:	how compare two versions of rdf file
Next Topic:	Only First Page in Report to be displayed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:59:51 CDT 2024