Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Difficult SQL Query
You can probably do a GOTO to the a label at the bottom of your function, and after the label have "return value" if you've setup value before you get the not found
-A
> Secondly, I am setting up a cursor in Pro*C and
> whenever not more records are found I want to return
> a failure value.
>
> Example:
>
> EXEC SQL WHENEVER NOT FOUND DO return value;
>
> The Pro*C compiler (2.2.2.0.0 on Solaris 7.3.2) keeps on
> complaining!
>
> Any help would be greatly appreciated.
>
> Many thanks,
>
> ---------------------------------------------
> James Bourne
> TAPS Development
> Telstra Multimedia Pty. Ltd.
> Phone: 02 9903 3435
> EMail: jbourne_at_nibupls1.telstra.comdotau
> (pls. replace dot with . to email me)
-- --------------------------------------------------------------------------- Archie Russell Scientific Applications Specialist Pangea Systems, Inc. 1999 Harrison Street, Suite 1100 Oakland, California 94612 ph 510-628-0100 ext 312 fx 510-628-0108 archier_at_pangeasystems.com http://www.pangeasystems.com http://www.csua.berkeley.edu/~archier ---------------------------------------------------------------------------Received on Mon Sep 15 1997 - 00:00:00 CDT