Re: Passing queries from procedure call in a script ... possible?

From: joel garry <joel-garry_at_home.com>
Date: Mon, 18 Aug 2008 10:56:57 -0700 (PDT)
Message-ID: <b66820e8-994d-4258-aed6-6464d9293d72@v16g2000prc.googlegroups.com>


On Aug 16, 3:14 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> 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
> DATES_TABLE.
>
> 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?
>
> Thanks.

Maybe http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:210612357425 and search for "silly question".

jg

--
@home.com is bogus.
Well, I'll probably be doing the big upgrade that weekend anyways:
http://www.signonsandiego.com/uniontrib/20080816/news_1m16alcohol.html
Received on Mon Aug 18 2008 - 12:56:57 CDT

Original text of this message