How can i extract the source of Procedure using query
I am using the below sql
SELECT
LISTAGG(TEXT,' ') WITHIN GROUP (ORDER BY LINE)
FROM USER_SOURCE
WHERE name ='PACK'
AND TYPE='PACKAGE BODY'
ORDER BY line;
SELECT * FROM USER_OBJECTS
But it is throwing error since string is more than 4000 bytes.
ORA-01489: result of string concatenation is too long
01489. 00000 - "result of string concatenation is too long"
*Cause: String concatenation result is more than the maximum size.
*Action: Make sure that the result is less than the maximum size.
How to resolve it?