Developer Studio can browse an Oracle database. We can also execute queries, DDL
and DML statements as shown above. However there are several restrictions on certain operations:
A user cannot execute anonymous block statements or stored procedures. Hence, triggers, procedures or functions cannot be created
in an Oracle database.
A user cannot create packages, procedures or functions on Oracle database using
EnterpriseDB Developer Studio.
Doing so will not raise an explicit error message instead a warning message will be displayed:
java.sql.SQLWarning: Warning: execution completed with warning.
SQL terminal cannot be opened for an Oracle database. Similarly Visual Explain and
EDB PL Debugger cannot be used in an Oracle database.