| how to run pl/sql package [message #87940] |
Thu, 08 November 2001 11:06  |
George
Messages: 68
Registered: April 2001
|
Member |
|
|
Could anybody help me to run the report in stored procedure? I created a report in the way below:
start report builder-> build report manually->(object Navigator)->program unit
created a pachage spec and body
When I go to the live viewer, it asked to create a layout, but the it asks a sql statement if I go layout model.
Is there any way to run this report or I did something wrong?
Also, how to run a stored procedure from the database, please provide as many details as you can since I am new to report.
Any help will be greatly appeciated
----------------------------------------------------------------------
|
|
|
|
| Re: how to run pl/sql package [message #87941 is a reply to message #87940] |
Fri, 09 November 2001 00:57  |
Ananda Manoharan
Messages: 1
Registered: November 2001
|
Junior Member |
|
|
In the Sql Prompt
type 'Execute my_procedure' ;
Before that you should have created the Prcedure and compiled it without errors...
************
Report..
You must first create datamodel( use sql statements) and then create the default layout and then run the report
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
