Home » Developer & Programmer » Reports & Discoverer » ORA-01576
ORA-01576 [message #302613] Tue, 26 February 2008 06:12 Go to next message
Messages: 18
Registered: February 2008
Location: Bangalore
Junior Member

from dual

When I tries to execute this select statement I am getting ORA-01576.

Please help me to find out.

Re: ORA-01576 [message #302614 is a reply to message #302613] Tue, 26 February 2008 06:17 Go to previous messageGo to next message
Messages: 269
Registered: September 2007
Senior Member

Cause: The thread associated with instance is not enabled.

Action: Enable the thread associated with the instance using ALTER DATABASE ENABLE INSTANCE command.
Re: ORA-01576 [message #302623 is a reply to message #302614] Tue, 26 February 2008 06:46 Go to previous message
Messages: 21151
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When you execute this SELECT statement, you get nothing. Its syntax is invalid.

First try to write it correctly. A hint: what is double pipe in
SELECT (|| CHR(39)
as well as in
CHR(39)||) FROM
supposed to do? Once you do that, and if still doesn't work, do come back and explain what you are trying to do.

What should be the result of this statement? For a certain input, which output do you expect?
Previous Topic: Excel output from Oracle Reports 3.0
Next Topic: Carry forward TOTALS(Cumulative Total)
Goto Forum:

Current Time: Wed Aug 23 14:33:27 CDT 2017

Total time taken to generate the page: 0.21098 seconds