Home » Developer & Programmer » Reports & Discoverer » OBE - 15065 Syntax Error (Win 7 64 - bit, Oracle Report 6i)
OBE - 15065 Syntax Error [message #622462] Tue, 26 August 2014 13:08 Go to next message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
Hello Everyone,

I am getting this error in query builder of Oracle report 6i. Can anybody help me what is the error in the SQL below

  SELECT   TO_CHAR (CMF_YR) || '/' || TO_CHAR (CMF_NO) COM_NO_STR,
           NO,
           QTY,
           PRICE,
           VALUE,
           LPO_TXF_DESC,
           SYS_DT
    FROM   LPO_DETAILS
   WHERE   CMF_TCF_CD = :p_TCF_CD AND CMF_YR = :p_YR AND CMF_NO = :p_NO
ORDER BY   NO
Re: OBE - 15065 Syntax Error [message #622463 is a reply to message #622462] Tue, 26 August 2014 13:23 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3171
Registered: May 2013
Location: World Wide on the Web
Senior Member
https://community.oracle.com/thread/209044?start=0&tstart=0

That OTN thread talks about a bug in older versions due to a space between the column name and the comparison operator. There was no feedback given there, can you at least try that and see.
Re: OBE - 15065 Syntax Error [message #622466 is a reply to message #622463] Tue, 26 August 2014 13:40 Go to previous messageGo to next message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
I have tried to remove the space between the column name and comparison operator but the same error is coming.
Re: OBE - 15065 Syntax Error [message #622473 is a reply to message #622466] Tue, 26 August 2014 15:12 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You seem to be running an unsupported combination of Oracle Reports and operating system. Although most of the time Reports work OK, unexpected & inexplicable errors can appear out of nowhere.

Do you use Query Builder? If so, avoid it. This is a simple query - type it directly into report's query; maybe it'll help.

Just to verify: if you have Reports 6i installation on Windows XP, create the same query in there and see what happens.
Re: OBE - 15065 Syntax Error [message #622481 is a reply to message #622473] Wed, 27 August 2014 00:14 Go to previous messageGo to next message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
Actually, I am trying to run this report on Win 7 (64 bit) but it gives me that Report Background Engine has stopped working. Only this report is having problem in the whole Oracle 6i system we have in our organisation.

If you run the same report in windows XP, it will run fine without giving any errors.

As only this report is giving an error while running so that I started suspecting this report that there is some bug in the report which is the reason of the error. I put SRW.MESSAGE() in triggers like Before Parameter Form, After Parameter Form and Before Report. All these trigger executed fine. While checking things step by step I got the OBE - 15065 Syntax Error in Query Builder. I started working on how to avoid this syntax error. This may be the reason behind the stopping of Report Background Engine.

Still I am confuse I dont know which way I have to go. If it is compatibility issue then no other Oracle 6i reports should work. but in my case all others Oracle 6i reports are working except this one.
Re: OBE - 15065 Syntax Error [message #622487 is a reply to message #622481] Wed, 27 August 2014 01:08 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I still don't understand why you insist on using Query Builder ... as I said, avoid it, create that query manually. Does it help?
Re: OBE - 15065 Syntax Error [message #622488 is a reply to message #622487] Wed, 27 August 2014 01:13 Go to previous messageGo to next message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
NO, I am not insisting to create query with Query Builder. While running this report I am getting an error "Report Background Engine has Stopped working". I thought the reason behind this can be this syntax error.

Please let me know how to figure out that why the Report Background Engine has stopped working.
Re: OBE - 15065 Syntax Error [message #622489 is a reply to message #622488] Wed, 27 August 2014 01:24 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't know that, sorry.

Here's what you could try, though: as this is the only report that doesn't work, maybe it is malformed; therefore, forget about existing report. Create a new one. Run report wizard and - when prompted for SQL query - paste the one you posted in the first message in this topic. Display all fields, let the wizard create layout (ugly but don't mind that).

Finally, run the report. Does it work, or does it throw the same error again? If it works, save it and make it pretty (by relocating fields, modifying labels, resizing & adjusting frames, etc.). Test frequently (after every step you make), save regularly. Hopefully, you'll make it work. If not, I'm afraid I don't have any other ideas.
Re: OBE - 15065 Syntax Error [message #622491 is a reply to message #622489] Wed, 27 August 2014 01:59 Go to previous message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
True. It is a long way but it is the only way i guess.

Thanks.
Previous Topic: Continue printing frame on next page.
Next Topic: Layout Problem
Goto Forum:
  


Current Time: Sun Oct 25 23:19:11 CDT 2020