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

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.

If I surround the line like so with a loop;

   while (i<1)
    {

        EXEC SQL EXECUTE q using :inputNumber;
        i++;

the code works and compiles successfully.

I am not sure why I need the loop, I went as far as to remove the EXEC SQL WHENEVER NOT FOUND DO break;
and the loop statements and compiler still complains;

Does anyone have any ideas on why I need this loop?

Thanks,
Chris

Frank van Bortel wrote:
> cmgray74_at_gmail.com schreef:
> > All,
> > I am trying to write a simple function that will allow a user to enter
> > a Update query similar to the one below on the command line.
>
> Don't!
> - it's a security risk.
> - it's a huge security risk
> - did you know it's a security risk?
> - security won't have it, because it's a risk
> - auditors will probably find it a huge risk, and
> will not allow it
>
>
> What version? What is the problem? Any error codes?
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Tue Oct 10 2006 - 12:49:53 CDT