Re: Calling a stored procedure from select
Posted by:
Carl Beebee
Date: September 04, 2007 03:21AM
I don't think it is possible, when ever I need to do something like that I create a view which performs all of the necessary calculations and use that (although this can have a performance overhead)
Depends if it's a one off task you need to perform or something that needs to be done all of the time, in which case you may need to add a trigger that calls a proceedure
Subject
Views
Written By
Posted
65526
July 16, 2007 12:02PM
Re: Calling a stored procedure from select
34006
September 04, 2007 03:21AM
24667
March 12, 2008 02:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.