Specifies whether the connection has read-only access to the data source.
Valid Values
true | false
Behavior
If set to true, the connection has read-only access. The following commands are the only commands that you can use when a connection is read-only:
Explain Plan
Select (except Select Into)
Set Schema
The driver returns an error if any other command is used.
If set to false, the connection is opened for read/write access, and you can use all commands supported by the product.
Caution: Before disabling the ReadOnly connection property, it is critical to confirm that all values in the primary key column are unique. Executing write operations against data with duplicate primary keys can produce unpredictable and undesirable results. See Designating a Primary Key for more information.
Notes
You also can use the JDBC connection method setReadOnly to set a read-only state for a connection.
Explain Plan