Re: How to check if a cursor has results?
From: Mike <y1799_at_yahoo.com>
Date: 10 Apr 2002 21:07:15 -0700
Message-ID: <93f42f92.0204102007.106db714_at_posting.google.com>
Date: 10 Apr 2002 21:07:15 -0700
Message-ID: <93f42f92.0204102007.106db714_at_posting.google.com>
cursor%FOUND
> I apologize in advance for this novice question.
>
> I am using Oracle 8 and I was wondering the PL/SQL syntax for checking
> if a cursor retrieved anything or not. So, given my statement
>
> OPEN p_cursor FOR select_stmt
> IF (p_cursor has results) THEN
> ...
> ELSE
> ...
> END IF
>
> what should I put for "p_cursor ahs results"?
>
> Thanks, Dave A.
Received on Thu Apr 11 2002 - 06:07:15 CEST