I am using Actuate 8 with oracle 9i client.
I have some SQL that when run in TOAD (under Oracle ver 8) works fine but when I paste this code into Actuate (under oracle 9i) and run it somes up with
ORA-00923 (FROM keyword not found where expected)
I am using the same oracle username/password to access the database so access is exactly the same.
Its a long sql script so wondering whether actuate is cutting off part of it before running?
Does anyone have any ideas?