Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!e3g2000cwe.googlegroups.com!not-for-mail
From: cmgray74@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Embedded SQL Question..... Please help......
Date: 10 Oct 2006 10:49:53 -0700
Organization: http://groups.google.com
Lines: 51
Message-ID: <1160502593.800729.122760@e3g2000cwe.googlegroups.com>
References: <1160499550.771599.160350@h48g2000cwc.googlegroups.com>
   <eggq9h$tn1$1@news4.zwoll1.ov.home.nl>
NNTP-Posting-Host: 208.46.47.5
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160502599 9218 127.0.0.1 (10 Oct 2006 17:49:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 17:49:59 +0000 (UTC)
In-Reply-To: <eggq9h$tn1$1@news4.zwoll1.ov.home.nl>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: e3g2000cwe.googlegroups.com; posting-host=208.46.47.5;
   posting-account=kLePdg0AAAA1K_S794Fa_4gyG8Sgcp-i
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276964

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@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...