Re: Passing queries from procedure call in a script ... possible?
Date: Sat, 16 Aug 2008 17:59:28 -0700
Dereck L. Dietz wrote:
> Oracle 10.2.0.3.0
> Windows 2003 Server
> UPDATE_PROCEDURE will update the DATES_TABLE but could be updated from
> different sources.
> How do I make the UPDATE_PROCEDURE able to accept different data sets
> retrieved from different cursors when the UPDATE_PROCEDURE procedure is
> called from different SQL scripts.
> I'm not experienced with reference cursors so I'm not sure if what I'm
> trying to do can be done or not. Would it be reference cursors, cursor
> variables or what?
> This UPDATE_PROCEDURE will be a packaged procedure which could be called by
> different processes to update the same table. However, each process will
> have different tables which create the data set to use to update the
> Currently this is all done in scripts and, for each process, there is a
> duplication of code for the update of the DATES_TABLE.
> Can a cursor be passed from a procedure call in a script and if so, is there
> any examples anywhere around?
Post the full and complete version and the DDL that creates the procedure.
Not one of us can see your monitor or read your mind. <g>
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Aug 16 2008 - 19:59:28 CDT