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

From: Clint Eastwood <cjundieseastwd_at_powerup.com.au>
Date: Wed, 08 Dec 1999 01:55:16 GMT
Message-ID: <82kden$1ad16_at_inetbws1.citec.com.au>

HiYa

[Quoted] [Quoted] 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 - 02:55:16 CET