Hi,
in SQL*PLUS it would not work as i tried,
but it worked with my SQLWindow (Pl/sql-Developer).
The problem could be the CLOB-Return-Type.

Try do implement a PL/SQL-Block and fetch the result into a PL/SQL-String.
and display the result with dbms_output()
porbably this could work.

Orca