Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Variable Cursors...
Answer is version specific.
Please specify your version *always*
There is no relationship between deleting a huge amount of records and a
variable cursor.
Regards,
Sybrand Bakker, Oracle DBA
<0> wrote in message news:3a2bc63e$1_4_at_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 - 16:02:23 CST