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: 20848
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: null values in parameter
Next Topic: how to call report made in 10g report in form 10g
Goto Forum:

Current Time: Fri Oct 21 12:13:02 CDT 2016

Total time taken to generate the page: 0.08353 seconds