Documentation
 
 
 

22.4. Restrictions

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.

 
 ©2004-2007 EnterpriseDB All Rights Reserved