| Re : Stored procedure [message #89963] |
Thu, 16 September 2004 20:47  |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
can any one help to how do create and use the stored procedure in the reports.
i am using oracle 8 with d2k
regards
|
|
|
|
| Re: Re : Stored procedure [message #89970 is a reply to message #89963] |
Sun, 19 September 2004 22:29  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Stored Procedures are Database objects and not Report or Form objects.
In Reports or Forms you may create Pl/Sql procedures and functions which are loacal top that component.
Regards
Himanshu
|
|
|
|
| Re: Re : Stored procedure [message #89979 is a reply to message #89970] |
Mon, 20 September 2004 09:42 |
reprts newbie
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
|
if i was trying to return a value from the stored procedure or function into that report...hoe can i do that...does report have a set item compability that isn't very apperant ( I looked in help and found nothing)
|
|
|
|
| Re: Re : Stored procedure [message #89984 is a reply to message #89979] |
Tue, 21 September 2004 00:41 |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Either you can store the value returned by a SP into a Placeholder column or in a Formula column & display in the report.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
