Hi
Tried to write a plsql statement as follows using dbms assert statements for alter profile, but getting errors.We want to prevent sql injections, so trying this approach.
DECLARE
BEGIN
EXECUTE IMMEDIATE 'ALTER profile sys.dbms_assert.enquote_name(sys.dbms_assert.simple_sql_name(DEFAULT)) limit failed_login_attempts || sys.dbms_assert.simple_sql_name(20)';
END;
Above statement gives the error as :
Error report:
ORA-02000: missing LIMIT keyword
ORA-06512: at line 3
It will be great if somebody can help.