Home » Developer & Programmer » Reports & Discoverer » How to create a report with package (Report 6i)
How to create a report with package [message #395057] Tue, 31 March 2009 03:55 Go to next message
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
Re: How to create a report with package [message #395512 is a reply to message #395057] Wed, 01 April 2009 12:53 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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?
Re: How to create a report with package [message #396122 is a reply to message #395512] Sat, 04 April 2009 01:33 Go to previous messageGo to next message
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

[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 Go to previous messageGo to next message
sajidrazmi
Messages: 47
Registered: August 2008
Location: oman
Member

And This Specification
Re: How to create a report with package [message #396162 is a reply to message #395057] Sat, 04 April 2009 07:49 Go to previous messageGo to next message
cookiemonster
Messages: 12403
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.
Re: How to create a report with package [message #396207 is a reply to message #396162] Sat, 04 April 2009 23:46 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you seen this thread?
http://forums.oracle.com/forums/thread.jspa?threadID=186012
Re: How to create a report with package [message #396516 is a reply to message #396348] Tue, 07 April 2009 01:26 Go to previous messageGo to next message
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.

Re: How to create a report with package [message #396567 is a reply to message #395057] Tue, 07 April 2009 04:07 Go to previous message
cookiemonster
Messages: 12403
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.
Previous Topic: how compare two versions of rdf file
Next Topic: Only First Page in Report to be displayed
Goto Forum:
  


Current Time: Sat Dec 03 18:30:20 CST 2016

Total time taken to generate the page: 0.07785 seconds