You cannot use a semicolon as a SQL delimiter in a set of DDL statements. As a result, you cannot type more than one DDL statement in the Post-cache replacement DDL statements text box, shown in Figure 4-9.
In a DDL statement, a table name must be of the form "schema_name"."table_name".
By default, column names in SQL Server database tables contain double quotes, for example "ACSPECIAL_CHAR". Oracle databases, however, do not support column names that contain double quotes. For this reason, you cannot cache an information object built from SQL Server database tables in an Oracle database without removing the double quotes from the column names in the cache table. If you attempt to do so, an error similar to the following appears:
|
|
Copyright Actuate Corporation 2012 |