×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

ORA-00923 message

ORA-00923 message

ORA-00923 message

(OP)
Hi

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?

thanks

RE: ORA-00923 message

in your obtainselect method of your datastream add a line after the obtainselect..
setclipboardtext(obtainselectstatement),
This should put your Sql into the clipboard so you can see what Actuate is using.

RE: ORA-00923 message

If you are pasting your SQL from an editor, cahnces are you are picking up some control characters. Be sure you don't have any control characters by removing all blank lines, and all spaces in the SQL, and reformat it with the space bar only. If you upgrade to version 9, this will never be an issue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close