Error Ora 00931
ORA-00931: missing identifier ORA-06512: at "SYS.DBMS_UTILITY", line 79 [message #3768] Thu, 17 October 2002 01:39 Conor Messages: 3Registered: October 2002 Junior Member I am using the comma_to_table listing have you any idea why I might be getting this : BEGIN * ERROR at line 1: ORA-00931: missing identifier ORA-06512: at "SYS.DBMS_UTILITY", line 79 ORA-06512: at "SYS.DBMS_UTILITY", line 108 ORA-06512: at "QPI.SPCOMMATOFILETBLUSERSITES", line 7 ORA-06512: at line 2 when I try running the comma to table stored procedure while not passing in "s" it works ok, however when I try passing in "s" I get errors in my SQL*Plus worksheet application ? This is what I use to run stored proc : set serveroutput on; BEGIN spcommatofiletblusersites('1,2,3,44,5'); END; This is the stored procedure : PROCEDURE "SPCOMMATOFILETBLUSERSITES" (sa IN VarChar2) IS s varchar2(30) := sa; a dbms_utility.uncl_array; len integer; begin dbms_utility.comma_to_table(replace(s, ',', ','), len, a); for i in 1..a.count loop dbms_output.put_line( a(i) ); end loop; end; New info : The stored procedure runs when I put double quotes around each character in the string like below : set serveroutput on; BEGIN spcommatofiletblusersites('"1","2","3","4","5"'); END; Output : "1" "2" "3" "4" "5" PL/SQL procedure successfully completed. But this is no use to me as I will be using a comma seperated file with possibly 000's of elements so the file cannot be updated to incl " " around each element. Any Ideas ? Report message to a moderator Re: ORA-00931: missing identifier ORA-06512: at "SYS.DBMS_UTILITY", line 79 [message #3770 is a reply to message #3768] Thu, 17 October 2002 02:28 Conor Messages: 3Registered: October 2002 Junior Member spcommatofiletblusersites('a,dd,g') works perfectly. It is only when string consists of numbers th
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Pivot in Oracle 11g up vote 1 down vote favorite I have http://www.orafaq.com/forum/t/1502/ searched Stackoverflow about pivot in Oracle 11g but could not find the syntax that works for my situation. Below is my query (runs in Oracle 11g). select age, gender, sum(hours) as hours from table1 group by age, gender Here is the O/P result age gender hours 25 Male 10 55 Female 5 45 Female 12 ...And here is my desired O/P result Age Male Female 25 10 0 45 0 http://stackoverflow.com/questions/23700034/pivot-in-oracle-11g 12 55 0 5 ...And here is my query select * from ( select age, gender, sum(hours) as hours from table1 ) pivot ( sum (hours) for gender in ( Male as 'Male', Female as 'Female') ) ...And here is the error: ORA-00931: missing identifier Could anyone please educate me please? oracle oracle11g pivot share|improve this question edited Nov 15 '15 at 13:31 APC 87.1k1384184 asked May 16 '14 at 16:14 joe 35941231 1 Not too familiar with pivot, but looks like you've got the quotes on the wrong side of the as in the pivot in clause ('foo' as foo) –Mat May 16 '14 at 16:20 select * from ( select age, gender, sum(hours) as hours from table1 ) pivot ( sum (hours) for gender in ( 'Male','Female') ) –Vijaykumar Hadalgi May 16 '14 at 16:20 Sure I did try it but the Male and Female columns show (null) as result. –joe May 16 '14 at 16:24 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote You were close: select age, nvl(male, 0) male, nvl(female, 0) female from ( select age, gender, sum(hours) as hours from table1 group by age, gender ) pivot ( sum(hours
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You https://community.oracle.com/thread/2227015 can not post a blank message. Please type your message and try again. More discussions in LCM: Maintenance Wizard All PlacesOracle ApplicationsE-Business SuiteE-Business Suite TechnologyLCM: Maintenance Wizard This discussion is archived 4 Replies Latest reply on Jun 6, 2011 4:44 PM by Lori Maintenance Wizard install: ORA-00931: missing identifier Sam_cl May 18, 2011 9:35 PM When installing the most recent Maintenance Wizard version error ora 2.18, I am getting the error in the logfile. The installation does proceed and finish.