Страница 1 из 1

oracle plsql question - multiple cursors in the same file

Добавлено: 18 мар 2008, 12:55
Gaziz
Привет,

Будут ли осложнения в таком коде если это все находится в одном файле?

DECLARE
CURSOR CUR1 IS [SKIP]
BEGIN
[SKIP]
END
/

DECLARE
CURSOR CUR1 IS [SKIP]
BEGIN
[SKIP]
END
/

DECLARE
CURSOR CUR1 IS [SKIP]
BEGIN
[SKIP]
END
/

Re: oracle plsql question - multiple cursors in the same file

Добавлено: 18 мар 2008, 13:21
anonim
Did you get any error message?
did you run it?
You can define as many cursors as you wish.

Re: oracle plsql question - multiple cursors in the same file

Добавлено: 18 мар 2008, 13:34
Gaziz
anonim писал(а):Did you get any error message?
did you run it?
You can define as many cursors as you wish.
thanks!

it runs ok - I am just asking for confirmations.

it will be automatically generated with hundreds of cursors with same name - I just want to make sure
no name clashes will happen...