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
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