Report Designer enforces invalid SQL for Oracle [message #551754] |
Mon, 09 August 2010 13:13 |
Jules Messages: 8 Registered: August 2010 |
Junior Member |
|
|
I've created a datasource on Oracle 10g thin driver ojdbc14-10.2.0.2.0.jar - OK
Now trying to create a dataset, I've pasted in a multi table join query in the style:
select a.col1, b.col2
from table1 a, table2 b
But the designer reworks the statement and inserts the 'AS' keyword between the table name and alias. e.g:
select a.col1, b.col2
from table1 AS a, table2 AS b
When trying to run the query it fails with ORA-00933. Copy pasting and trying to execute in TOAD delivers the same. Remove the 'AS' keywords and it works as expected.
The Oracle documentation says the 'AS' is optional but dba's say actually its not acceptable by Oracle. this seems like a very basic problem and being new to BIRT I can't see where to configure anything to make a difference.
If I edit out the 'AS' it just puts it back in every time.
Can anyone advise?
[Updated on: Mon, 09 August 2010 13:14] Report message to a moderator
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.02100 seconds