OraFAQ Forum: Reports & Discoverer » OBE

Home » Developer & Programmer » Reports & Discoverer » OBE - 15065 Syntax Error (Win 7 64 - bit, Oracle Report 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OBE - 15065 Syntax Error [message #622462]

Tue, 26 August 2014 13:08

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

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622463 is a reply to message #622462]

Tue, 26 August 2014 13:23

Lalit Kumar B
Messages: 3174
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.

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622466 is a reply to message #622463]

Tue, 26 August 2014 13:40

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.

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622473 is a reply to message #622466]

Tue, 26 August 2014 15:12

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622481 is a reply to message #622473]

Wed, 27 August 2014 00:14

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.

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622487 is a reply to message #622481]

Wed, 27 August 2014 01:08

Littlefoot
Messages: 21807
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?

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622488 is a reply to message #622487]

Wed, 27 August 2014 01:13

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.

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622489 is a reply to message #622488]

Wed, 27 August 2014 01:24

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: OBE - 15065 Syntax Error [message #622491 is a reply to message #622489]

Wed, 27 August 2014 01:59

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 02:53:35 CDT 2024