Re: Syntax error in Pro*C

From: Shawn Lavin <shawn_at_mdli.com>
Date: 1996/07/31
Message-ID: <31FF73B5.41C6_at_mdli.com>#1/1


[snip]
> Syntax error at line 1417, column 49, file srf.pc:
> EXEC SQL SET TRANSACTION USE ROLLBACK SEGMENT :rback;

> ..............................................................1
[snip]

The reason that it does not like rback is actually quite simple. Anything that you are going to use in the syntax :anything should be declared to SQL before you use it.

The syntax is usually :

EXEC SQL BEGIN DECLARE SECTION;
  varchar rback[4];
EXEC SQL END DECLARE SECTION; Hopefully this helps.

Shawn Lavin
As always, my opinions are my own Received on Wed Jul 31 1996 - 00:00:00 CEST

Original text of this message