An error occurred in RDSADMIN.RDS_FILE_UTIL when fetch data

Question

An error occurred in RDSADMIN.RDS_FILE_UTIL when executing the following SQL during Oracle.
Could you please tell me the cause of the error and how to deal with it?
SQL statement：

> SELECT *
FROM table(RDSADMIN.RDS_FILE_UTIL.LISTDIR(p_directory => 'BDUMP'))
FETCH FIRST 100 ROWS ONLY;.

Error contents：
 (There are more than 1000 files in the BDUMP folder.)

SQL : SELECT *
FROM table(RDSADMIN.RDS_FILE_UTIL.LISTDIR(p_directory => 'BDUMP'))

FETCH FIRST 100 ROWS ONLY

SQL : ORA-20199: Error in rdsadmin.rds_file_util.

ORA-06512: "RDSADMIN.RDS_FILE_UTIL", line 30

ORA-06548: No more lines are needed

ORA-06512: "RDSADMIN.RDS_FILE_UTIL", line 23

Answer

Hello,

You can rewrite your query as below to fetch first 1000 rows .

select * from (SELECT * FROM table(RDSADMIN.RDS_FILE_UTIL.LISTDIR(p_directory => 'BDUMP'))) fetch first 1000 rows only;

or

select * from (SELECT * FROM table(RDSADMIN.RDS_FILE_UTIL.LISTDIR(p_directory => 'BDUMP'))) where rownum < 1000;

An error occurred in RDSADMIN.RDS_FILE_UTIL when fetch data

Relevant content