Shree Naath Shree Naath - 11 months ago 49
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 Source

The documentation lists the constants, including:

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);


PL/SQL procedure successfully completed.