Re: Embedded SQL Question..... Please help......

The EXEC SQL WHENEVER NOT FOUND DO break;

I think I get what your saying;

the break statement is expecting the loop;

I have removed the break and added a error message display function;

    EXEC SQL PREPARE q FROM :sql_statement;

    EXEC SQL WHENEVER NOT FOUND DO sql_error("ORACLE error:");

    EXEC SQL EXECUTE q using :inputNumber;

    EXEC SQL COMMIT work release;

This seems to work just fine.

Does this seem reasonable?

Thanks,
Chris

Frank van Bortel wrote:
> cmgray74_at_gmail.com schreef:
> > All,
> > This is more of a assignment then a work project; they kinda go hand in
> > hand right now.
> >
> > The issue is a Compiler issue; (Oracle 8i, Unix)
> >
> > Complains that there is the following error;
> >
> > Error: This break is not in a loop or switch.
> >
> What does the line:
>
> EXEC SQL WHENEVER NOT FOUND DO break;
>
> tell you? Or the compiler?
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Tue Oct 10 2006 - 13:34:32 CDT