Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Given SQL statement is not allowed to be executed at this time.

Sravani36
Tera Expert

‎03-12-2023 08:54 PM

Hi I am trying to execute the SQL statement as below

'select DBMS_METADATA.GET_DDL(''FUNCTION'',''' || LIMIT || ''',''SYS'') from DUAL'   from dba_profiles where RESOURCE_NAME = 'PASSWORD_VERIFY_FUNCTION'  and  limit !='NULL' order by PROFILE

Sravani36_0-1678679437279.png

Sravani36_1-1678679564144.png

How to fix this error?

 

0 Helpfuls
  • 488 Views
0 REPLIES 0