Re: any way to execute stored procedure from view ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 2 Apr 2001 22:02:37 +0200
Message-ID: <tchntoo4njn98b@beta-news.demon.nl>

Evidently you can't execute a stored procedure by nature of the concept of a stored *procedure*, as a procedure doesn't return a result. You can however use a stored *function* as this return a single result. Also it should really return a *single* result (so *no* resultsets), and functions in this context result in recursive sql. In short, better think twice before you embark on this route.

Regards,

Sybrand Bakker, Oracle DBA

"Edgar" <_mark_@_something_.com> wrote in message news:AR0y6.176497$Z2.2150042_at_nnrp1.uunet.ca...
> probably I am asking for something impossible...
> I use Oracle 8.1i
>
> thanks for answer
> Marek
>
>
>
Received on Mon Apr 02 2001 - 15:02:37 CDT