| ORA-00604 and ORA-01009 [message #403504] |
Sat, 16 May 2009 01:01  |
ejaz@cacts.com.bd
Messages: 1
Registered: May 2009
Location: Bangladesh
|
Junior Member |
|
|
Hello,
I have had Oracle Database 10g Version 10.2.0.1.0 and Oracle Developer 10g version 9.0.4
installed on windows 2003 server std edition which was working well. I upgraded the O/S to windows 2008 server std edition. Now the sql is working but I received the follwoing error message when I try to connect the Database in Form Developer.
ORA-00604: error occured at recursive SQL Level 1
ORA-01009: missing mandatory parameter
and when try to run Report Bulder the error msg is
REP-0501 : unable to connect to the specified database.
ORA-00604: error occured at recursive SQL Level
can you please help me to solve this problem.
Regards
Ejaz
|
|
|
|
|
|
| Re: ORA-00604 and ORA-01009 [message #416652 is a reply to message #403504] |
Mon, 03 August 2009 14:04  |
wbadmin
Messages: 2
Registered: January 2009
Location: USA
|
Junior Member |
|
|
Error Message: ORA-00604 error occurred at recursive SQL level
Error Cause:
An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
Action:
If the situation described in the next error on the stack can be corrected
Error Message: ORA-01009 missing mandatory parameter[/url]
Error Cause:
A host language program call did not pass all required parameters.
Action:
Check the syntax for the call and enter all required parameters.
Error Message: REP-00501: Unable to connect to the specified database.
Cause:
Reports Builder tried to but could not connect to ORACLE. The possible causes of this error include the following: Case 1: ORACLE is temporarily unavailable. Case 2: Your connect information was not valid.
Action:
You can take the following actions to correct this error: If Case 1: Retry the operation. Contact your DBA if the problem persists. If Case 2: Check your connect information to make sure it is correct. If it is not, re-enter it and try to connect again.
[Updated on: Mon, 03 August 2009 14:28] by Moderator Report message to a moderator |
|
|
|
| Re: ORA-00604 and ORA-01009 [message #416665 is a reply to message #403504] |
Mon, 03 August 2009 15:12 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Reports Builder tried to but could not connect to ORACLE.
This is no a database problem but Reports Server problem.
Post Operating System (OS) name & version for DB server system.
Post results of SELECT * from v$version.
Post Operating System (OS) name & version for Reports Server system.
Post Oracle version to 4 decimal place of Reports Server s/w.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
