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: 7055
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: 59993
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: 2078
Registered: January 2010
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 Dec 19 14:45:27 CST 2014

Total time taken to generate the page: 0.10941 seconds