| Pivot operator [message #93231] |
Thu, 15 January 2004 09:51 |
Charlie
Messages: 35
Registered: March 2001
|
Member |
|
|
I was practicing with the example in the oracle doc to load data from a flat file to a table using oracle warehouse builder.
when I validated it, It gave me this error saying this long msg:
VLD-1111: An invalid combination of operators prevents the generation of code in a single implementation language (PL/SQL code, or SQL*Loader code, or ABAP code). For example, you may have included a SQL*Loader only operator such as the Data Generator in a mapping with a PL/SQL implementation type. If you designed the mapping to generate PL/SQL code, an invalid combination or sequence of operators prevents the generation of PL/SQL code in any of the operating modes(set based, row based, row based target only). If the mapping contains an operator that generates only PL/SQL output, all downstream dataflow operators must also be implementable by PL/SQL. You can use SQL operators in such a mapping only after loading the PL/SQL output to a target. Detail is as follows:
PL/SQL set based operating mode: Operator pivot_test_csv does not support SQL generation.
PL/SQL row based operating mode: Operator pivot_test_csv does not support SQL and PL/SQL generation.
PL/SQL row based (target only) operating mode: Operator pivot_test_csv does not support SQL and PL/SQL generation.
Both SQL and PL/SQL handlers are not supported by pivot_test_csv as output
SQL*Loader: Operator PIVOT does not support SQL*Loader generation.
ABAP: Operator pivot_test_csv does not support ABAP generation.
Can anyone help?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
