Book Image

Oracle APEX Best Practices

Book Image

Oracle APEX Best Practices

Overview of this book

Have you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it."Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you'll need. "Oracle APEX: Best Practices" is where practical development begins!
Table of Contents (14 chapters)
Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

How to check if network services are enabled


Network services need to be enabled for Oracle RDBMS version 11 and higher. When an error occurs in the printing, the network services need to be checked.

select acl, principal, privilege, is_grant from dba_network_acl_privileges;

The outcome is as follows:

ACL					Principal		Privilege		Is_Grant
/sys/acls/power_users.xml	APEX_040100	Connect		True

The preceding query will check the necessary privileges that are needed for the printing feature in Application Express. These rows need to be present for enabling printing. If the necessary privileges are not granted when you are printing, the following error will be generated:

ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified

When there are no rows, ACL needs to be added. The code needed to fix this problem is available in the Installation Guide from Application Express, under the header 3.3.7 Enable Network Services...