Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Is "start transaction" not parameterizable?
Tue, Nov 9 2010 5:02 AMPermanent Link

durumdara

Hi!

proc A (in WhatTable)

a)
start transaction on tables WhatTable

b.)
execute immediate "start transaction on tables" || WhatTable

Every of them is wrong.

May some commands/statements are not parameterizable?

EDB 2.03.23

Thanks:
  dd
Wed, Nov 10 2010 6:22 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Krisztian,

<< a)
start transaction on tables WhatTable

b.)
execute immediate "start transaction on tables" || WhatTable

Every of them is wrong.

May some commands/statements are not parameterizable? >>

You can use string expressions with the TABLES clause in 2.04 and higher.
In 2.03 and earlier versions, the TABLES clause required hard-coded table
names.  See the release notes for more information:

http://www.elevatesoft.com/download?action=info&category=edb&type=edbvcltrial&majorversion=2&version=2.04#releasenotes

under "2.04 Breaking Changes".

--
Tim Young
Elevate Software
www.elevatesoft.com
Image