Home » RDBMS Server » Server Administration » is there a way to install WMSYS in Oracle XE 11.2.0.2 (11.2.0.2. XE SLES SP2)
is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #650843] Thu, 05 May 2016 06:11 Go to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

I've was given the task to try our application on Oracle Express 11.2.0.2 due to licensing issues.

So what I did was export all the relevant schema from 11.2.0.1 EE to 11.2.0.2 XE.

however I encounter the following problem:

this portion of the code is invalid and our application needs to use this code
SELECT member_id, 
       Substr(Wm_concat(address), 0, 2000) email 
FROM   t 
GROUP  BY member_id;


so next I go to the 11.2.0.1 EE Db and found out what is wm_cat.
column owner format a6
column object_name format a9
column object_type format a8

SELECT owner, 
       object_name, 
       object_type 
FROM   dba_objects 
WHERE  object_name = Upper('wm_concat'); 



output
SYS@poznan>SELECT owner, object_name, object_type FROM dba_objects WHERE object_name=upper('wm_concat');

OWNER  OBJECT_NA OBJECT_T
------ --------- --------
PUBLIC WM_CONCAT SYNONYM
WMSYS  WM_CONCAT FUNCTION




So how can I install WMSYS?

from http://www.orafaq.com/forum/mv/msg/156954/452298/#msg_452298
owmctab.plb



But I could not found the code in $ORACLE_HOME/rdbms/admin

many thanks in advance
Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #650844 is a reply to message #650843] Thu, 05 May 2016 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use LISTAGG, WM_CONCAT which no more exists in subsequent versions, is for Oracle use ONLY.

Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652430 is a reply to message #650844] Wed, 08 June 2016 15:22 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Not only is it for Oracle internal use only, I have read that it is not going to be even in oracle 12.
Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652432 is a reply to message #652430] Wed, 08 June 2016 17:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I thought this is what I said but of course my English might make it not understandable. Smile

Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652439 is a reply to message #652432] Thu, 09 June 2016 00:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, you'd want to hear my French, then.
Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652658 is a reply to message #652439] Wed, 15 June 2016 14:45 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Sorry Michel, I missed your note before I wrote mine.
Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652681 is a reply to message #652439] Thu, 16 June 2016 03:08 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
It's probably way better than my Croatian!
Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652749 is a reply to message #652681] Fri, 17 June 2016 15:16 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
The nice thing about the wm_concat is that it returns a clob so it can have very long results. The listagg returns a maximum of 4000 characters. However it is easy to sort using wm_concat and the code is easy to pull from the database and put into XE. However if you do that do NOT put it in SYS, use another schema with a public synonym pointing to it. I loaded it into my 11g XE database and it works great.
Re: is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #652753 is a reply to message #652749] Sat, 18 June 2016 01:01 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I posted several extensions of T. Kyte's STRAGG function, including one returning a CLOB there.
Previous Topic: Do I need to remove OLAP components
Next Topic: Checkpoint not complete
Goto Forum:
  


Current Time: Thu Mar 28 10:52:36 CDT 2024