Re: insert into returns 0 rows

Pls do not crosspost

Use a cursor ?

Fetch Your_cursor
If Your_cursor%NotFound
Then ...

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Agoston Bejo" <gusz1_at_freemail.hu> a écrit dans le message de
news:clo7dl$iev$1_at_news.caesar.elte.hu...


> Hi,

> when a SELECT in an INSERT INTO statement returns no rows, NO_DATA_FOUND

> exception is raised. How do I write a "nice" SELECT INTO when I expect

that


> 0 or 1 row gets returned, and the variable should be NULL if no rows are

> returned.

> By "nice" I mean that my intention is clear from the source code and no

> exception-catching is involved, since that would suggest that I'm handling

> such a condition that shouldn't occur.

> Therefore the following two techniques are not satisfying:

>

> SELECT MIN(thefield) INTO myvar ... -- (not clear what is intended)

>

> BEGIN --exception handling where no real exceptional condition occurs

> SELECT thefield INTO myvar...

> EXCEPTION WHEN NO_DATA_FOUND THEN

> myvar := NULL

> END;

>

>

>

>