As most developers know the PL/SQL function library is very comprehensive and there are packages for almost every task a developer has to accomplish.
But there are still requirements for which no PL/SQL package is avaliable - examples are:
* Retrieve directory listings from the database server's filesystem
* Create or Unpack ZIP archives
* Retrieving Mails from a IMAP or POP3 server
* Transferring LOB data from a remote database
The presentation shows how the database-internal JVM can be used in order to accomplish these tasks. The JVM will be introduced, the differences between the database JVM and a "normal" JVM and finally an example how to create a java stored procedure and access it from SQL and PL/SQL will be shown.
Vrsta: Predavanje / Lecture
Razina težine: Vrlo detaljno i stručno / Expert
Poželjno iskustvo slušatelja: Iskusni (2-3 g.) / Experianced
Poželjna funkcija slušatelja:
Sistem Analitičar / System Analist
Developer
Dizajner / Designer
Predviđeno vrijeme trajanja rada - aktivnosti: 30 min
206_Czarski Breaking limits with the DB JVM.pdf 323,33 kB
Oracle Deutschland, Business Unit Database
Carsten Czarski works for Oracle Germany since 2001. He is responsible for counseling customers and partners regarding the adoption of Oracle database technology. A special focus area of his work is Oracle Application Express supporting the german community.
Carsten is editor of the german APEX community webpage and a regular speaker at the german Oracle Users group.