I have read from many sites and learnt that native is a constant in the dbms_sql package. But what is the value stored in the constant? Please do correct me if I went wrong somewhere.
The documentation lists the constants, including:
Description: Specifies normal behavior for the database to which the program is connected
You could also have found it out by displaying it, e.g. from SQL*Plus or SQL Developer:
set serveroutput on exec dbms_output.put_line(dbms_sql.native); 1 PL/SQL procedure successfully completed.