Comments
4 comments
-
Hi,
I'm sorry that you've run into this problem. As you correctly point out the problem is caused by the column names containing special charcaters, but not being enclosed in quotes. I've marked this as a bug against our product - ODC-193.
Is it difficult for you to rename those columns to add the missing quotes?
Kind regards, Tom
Tom Harris,
Red Gate Software -
It's impossible to change column name becasue the 2 database are repository of an application data and the table cannot be changed.
Bye -
Hi there,
this issue has now been fixed. Please email productsupport@redgate.com to get an updated installer
Kind regards, Tom
Tom Harris, Red Gate Software -
Hi there,
the fix for the issue is now incorporated into the Red Gate Oracle tools download. You can grab the latest version from
http://www.red-gate.com/products/oracle-development/
Kind regards, Tom
Tom Harris, Red Gate
Add comment
Please sign in to leave a comment.
Bug report generated at 07/03/2011 12.03.11
Program version 1.0.1.346
System.Exception: Couldn't execute statement:
SELECT SEQUENCE, LASTMODIFIED, LASTUSER, _GROUP_, _INACTIVE_:, COMMITMENT_ID, FISCAL_YEAR, COMM_AMOUNT FROM "_SMDBA_"."BUDG_COMM" ORDER BY SEQUENCE ---> Devart.Data.Oracle.OracleException: ORA-00911: invalid character
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.an.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
--- End of inner exception stack trace ---
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.OracleDBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.DataComparer.Compare()
at RedGate.Oracle.Compare.EngineController.Data.DataCompareEngine.#t.#GKb.#UsY()
at RedGate.Shared.Controls.ProgressDialogEx.e()
if we remove _GROUP_ and _INACTIVE_: colmuns from compare all work fine.
it's enough that column name be in double quotes (") to solve this problem , how can I do that ?
thanks in advance for help