Shree Naath Shree Naath - 1 month ago 6
SQL Question

What is the value of dbms_sql.native?

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.

Answer

The documentation lists the constants, including:

Name: NATIVE
Type: INTEGER
Value: 1
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.