Pro*C - internal vs external variables
From: Clint Eastwood <cjundieseastwd_at_powerup.com.au>
Date: Tue, 07 Dec 1999 03:05:30 GMT
Message-ID: <82ht6f$1ac8_at_inetbws1.citec.com.au>
HiYa
Motorcyclist and dingbat Received on Tue Dec 07 1999 - 04:05:30 CET
Date: Tue, 07 Dec 1999 03:05:30 GMT
Message-ID: <82ht6f$1ac8_at_inetbws1.citec.com.au>
HiYa
can I declare a variable of type in my code, and access this using EXEC SQL calls?
For example, if I want to use an Oracle DATE type in my code, and I do
exec sql select sysdate into :mydate from dual;
and then access this and manipulate this using the sort of statements that I can do in PL/SQL
BEGIN
mydate := mydate + 1;
END;
thanks
See Ya
(when the bandwidth gets better ;-)
Chris Eastwood Please remove undies for replyPhotographer, Stunt Programmer
Motorcyclist and dingbat Received on Tue Dec 07 1999 - 04:05:30 CET