Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Difficult SQL Query

Re: Difficult SQL Query

From: Archie Russell <archier_at_pangeasystems.com>
Date: 1997/09/15
Message-ID: <341E29E8.DDB1648D@pangeasystems.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US