Re: Why the #$%^ won't this Pro*C command work?!?!

In article <4gfblj$d0i_at_inet-nntp-gw-1.us.oracle.com>, 73125.1040_at_compuserve.com (Mark Tomlinson) writes:
|> 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....
|>
You are trying to run a PL/SQL block. The ORA-900 error means that you probably haven't linked PL/SQL into the kernel. Can you run the block from SQL*Plus? I doubt it. If not, then run the installer and select 'PL/SQL' to relink Oracle with PL/SQL. I also think you can do this with oracle.mk, but I'm not exactly sure how. Received on Wed Feb 21 1996 - 00:00:00 CET