Re: Pro*C - mixing SQL and PL/SQL in the module

Hi,

You could try to use sqlcheck=full

Wim

Clint Eastwood <cjundieseastwd_at_powerup.com.au> wrote in article <82kden$1ad16_at_inetbws1.citec.com.au>...
> HiYa
>
> I think that this isn't possible .. is that right? it seems that from
> the manual, that I have to set SQLCHECK to either SEMANTICS or SYNTAX ,
> and that means that I can't have both ... is that right?
>
> the reason that I wanted to use both is that I want to be able to
> declare cursors, and use for loops, and I don't think that this is as
> easy without PL/SQL.
>
> However, on other occasions I want to do things that are just as easily
> done with SQL ... any suggestions as to the benefits of either paradigm
> are appreciated, as I am feeling a little confused as to the best
> approach
>
>
> thanks
>
>
>
>
> See Ya
> (when the bandwidth gets better ;-)
> Chris Eastwood Please remove undies for reply
> Photographer, Stunt Programmer
> Motorcyclist and dingbat
>
Received on Wed Dec 08 1999 - 13:52:47 CET