Problem substituting inline parameter value in alter table statement

2009-08-25 Thread Evan McQuinn
Hello - I'm trying to run an alter table command to swap partitions in a large Oracle table. I haven't found any documentation regarding alter table in iBatis specifically, so I'm using the update mapping. Seems straightforward enough, but for some reason my inline #value# parameter is not

Re: Problem substituting inline parameter value in alter table statement

2009-08-25 Thread Evan McQuinn
Answered my own question: I just discovered that I'd missed the subtle syntax difference between dynamically provided parameters and actual chunks of sql; I need to use $value$ instead of #value#. Sorry 'bout that. - Evan Evan McQuinn wrote: Hello - I'm trying to run an alter table

Re: Problem substituting inline parameter value in alter table statement

2009-08-25 Thread Nathan Maves
you need to use the string substitution option. $value$ nathan On Tue, Aug 25, 2009 at 4:15 PM, Evan McQuinn evan.mcqu...@noaa.gov wrote: Hello - I'm trying to run an alter table command to swap partitions in a large Oracle table. I haven't found any documentation regarding alter table in