| ORA-01576 [message #302613] |
Tue, 26 February 2008 06:12  |
joeslee
Messages: 18
Registered: February 2008
Location: Bangalore
|
Junior Member |
|
|
select(||CHR(39)||
REPLACE(&p_ch_account_id,',',CHR(39)||','||
CHR(39))||CHR(39)||)
from dual
When I tries to execute this select statement I am getting ORA-01576.
Please help me to find out.
Cheers,
Joeslee
|
|
|
|
| Re: ORA-01576 [message #302614 is a reply to message #302613] |
Tue, 26 February 2008 06:17  |
spmano1983
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 |
 |
Littlefoot
Messages: 21823
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 inas well as insupposed 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
