Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00904: : invalid identifier in oracle 11G (Oracle 11G Edition Release 11.2.0.1.0 )
ORA-00904: : invalid identifier in oracle 11G [message #596525] Tue, 24 September 2013 06:12 Go to next message
manojkakkar@gmail.com
Messages: 1
Registered: September 2013
Junior Member
Hi,

I have created one user in DB using below command

SQL> create user user1 identified by user1;

User created.




SQL> grant dba to user1;

Grant succeeded.

SQL>




I am trying to run below query

SQL> select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual;
select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual
*
ERROR at line 1:
ORA-00904: : invalid identifier


SQL>


Problem :- I am getting "ORA-00904: : invalid identifier" even after giving the DBA right to user.



When I run the same query using the sysdba , I am able to run the query

SQL> conn / as sysdba
Connected.
SQL> select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual;

DBMS_RANDOM.VALUE(-9223372036854775808,9223372036854775807)
-----------------------------------------------------------
-5.113E+18

SQL>


. Please help me to get the issue solve.

Re: ORA-00904: : invalid identifier in oracle 11G [message #596529 is a reply to message #596525] Tue, 24 September 2013 06:27 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Can you execute
select sys.dbms_random.value(-9223372036854775808, 9223372036854775807) 
from   dual;


MHE
Re: ORA-00904: : invalid identifier in oracle 11G [message #597350 is a reply to message #596529] Thu, 03 October 2013 10:05 Go to previous messageGo to next message
sajeel_87
Messages: 3
Registered: July 2012
Location: Chennai
Junior Member
may i know which Oracle version you are using..both these below queries are working in 11g,

select sys.dbms_random.value(-9223372036854775808, 9223372036854775807) from   dual;

select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual;
icon13.gif  Re: ORA-00904: : invalid identifier in oracle 11G [message #597352 is a reply to message #597350] Thu, 03 October 2013 10:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ The version is in the title
2/ This has been asked by Maarten
3/ The result is in the first post
So point 2) is the key point and if OP didn't answer to Maarten's question this is because he then found his error in executing the query but didn't find interesting to post us any feedback.
There may be different answers; for instance, the synonym does not exist or the user has not the privilege to execute the package.


Re: ORA-00904: : invalid identifier in oracle 11G [message #597367 is a reply to message #596525] Thu, 03 October 2013 17:27 Go to previous message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
manojkakkar@gmail.com wrote on Tue, 24 September 2013 07:12
Please help me to get the issue solve.


I suggest you contact DBA. By default procedural option creates DBMS_RANDOM package, a public synonym DBMS_RANDOM and grants execute to public. So, unless public synonym/execute to public was removed on purpose, what you are experiencing might indicate there were issues creating database.

SY.
Previous Topic: error when using return along with ref cursor
Next Topic: Loading Data from one remote Server into another Remote server Database....
Goto Forum:
  


Current Time: Fri Mar 29 10:17:02 CDT 2024