| is there a way to install WMSYS in Oracle XE 11.2.0.2 [message #650843] |
Thu, 05 May 2016 06:11  |
 |
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
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 #652749 is a reply to message #652681] |
Fri, 17 June 2016 15:16  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
