Re: Why the #$%^ won't this Pro*C command work?!?!
From: Mark Tomlinson <73125.1040_at_compuserve.com>
Date: 1996/02/21
Message-ID: <4gfblj$d0i_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/02/21
Message-ID: <4gfblj$d0i_at_inet-nntp-gw-1.us.oracle.com>#1/1
stollj_at_ncr.disa.mil wrote:
# I'm a novice Pro*C user who's trying to get some basic C code (as
taken from the ORACLE DOCUMENTATION!!!) to run. When I put the syntax
# EXEC SQL EXECUTE..BEGIN..END;..END-EXEC; (with some simple SQL such
as SELECT 1 INTO :tmp_num FROM dual; between the BEGIN & END; - where
I
# define tmp_num as an integer before the EXEC SQL EXECUTE block), I
get an 'Invalid SQL statement' error message. WHAT'S GOING ON?? WHAT
AM I DOING
# WRONG?? PLEASE HELP!!!!!!!!!!
# Frustrated,
#
# Jim Stoll
Get rid of the trailing semi-colon.... Received on Wed Feb 21 1996 - 00:00:00 CET