Home » SQL & PL/SQL » SQL & PL/SQL » WM_CONCAT (Oracle, 10g, Windows server 2003)
WM_CONCAT [message #494660] |
Wed, 16 February 2011 06:56  |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |

|
|
Hi,
Consider the following query
SELECT WM_CONCAT(DISTINCT '"'||ename||'"') E
FROM emp
E
-------
"ADAMS","ALLEN","BLAKE","CLARK","FORD","JACK","JAMES","JONES","KING","MACK","MARTIN","MIKE","MILLER","SCOTT","SMITH","TURNER","WARD"
This is running fine outside a procedure but inside a procedure it says
SQL> CREATE OR REPLACE PROCEDURE test23 IS
2 coll VARCHAR2(100);
3 BEGIN
4 SELECT WM_CONCAT(DISTINCT '"'||ename||'"') E
5 INTO coll
6 FROM emp;
7 END;
8 /
Warning: Procedure created with compilation errors.
SQL> show err
Errors for PROCEDURE TEST23:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/7 PL/SQL: SQL Statement ignored
4/14 PL/SQL: ORA-30482: DISTINCT option not allowed for this function
Please tell a solution for this?
Regards,
Ritesh
|
|
|
|
|
Goto Forum:
Current Time: Tue Apr 29 19:58:24 CDT 2025
|