Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Variable Cursors...

Variable Cursors...

From: <0>
Date: Mon, 4 Dec 2000 16:24:12 -0000
Message-ID: <3a2bc63e$1_4@news.arrakis.es>

How can I have a cursor for a variable SELECT statement?

I'm trying to make a general procedure to delete some records from a table.
This procedure will be applyed for different tables. We think that we need to use a variable cursor because of the big amount of records to be deleted.

So we need only one cursor with a variable SELECT statement that will return different kinds of records depending on the table.

Thanks,

--
Ricardo Sánchez Berbegal
Mobile Systems S.I., S.A.
Received on Mon Dec 04 2000 - 10:24:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US