Calling a Java class in PL/SQL
loadjava -user username/password@SID -force -resolve MyPath\MyFile.java
Call dbms_java.grant_permission('<FUNCTION_OWNER>','java.io.FilePermission','writeFileDescriptor',null);
Call dbms_java.grant_permission('<FUNCTION_OWNER>',',java.io.FilePermission','readFileDescriptor',null);
create or replace FUNCTION MyFunction RETURN VARCHAR2 as language java name 'myPackage.MyClass.myMethod() return String';
links |
|
Database developmentOracle 10g Database Migration ReasonsOracle 10g Database Migration Reasons A few weeks ago, we were at a customer who wanted to install a new database. They already had multiple 10g databases and needed to add an additional one. Because the project will cover a period of 6 months, the first thing we did was checking the lifecycle of the 10g database. To our surprise, database 10g is no longer supported in Premier Support,... UTL_FILE will not do implicit character conversionUTL_FILE will not do implicit character conversion Recently we migrated a database from one server to another. We used this occasion to change the character set of the database from WE8ISO8859P15 to AL32UTF8. After this migration we started to see invalid characters in our database tables. This was due to the fact that utl_file will not use the NLS_LANG settings of your OS. So if on your... JavaNumber column as booleanNumber column as boolean When you use an Oracle database, you don't have a boolean type to use in your tables. Usually, you work around this problem by using a numeric column with values 0 and 1. This however could cause some extra programming work when building an application on top of your database. The numbers have to be converted to booleans, and vice versa. Now, in ADF... ADF @ BlackBelftFactoryADF @ BlackBelftFactory Contribute and Contribute4J are proud to inform you that BlackBeltFactory (formerly JavaBlackBelt) now has an ADF exam online. Feel free to contribute! http://forums.oracle.com/forums/thread.jspa?threadID=1101786 ADF productivityIncrease your JEE development productivity with Oracle ADF Java EE is a standard, robust, scalable, and secure platform that forms the basis for many of today’s enterprise applications. Java EE provides a set of specifications for building multi-tier applications using the JavaTM language. In the past, there was a direct correlation between the robust nature of an... Nexus and mavenNexus and maven Read More New Spring 3 MVC modelNew Spring 3 MVC model Intro Creating web applications with spring 3 has become a lot easier. Restful URL are easily manageable using annotations. This is a real pleasure for developing web applications. A bare minimum of XML is required, just to scan the annotations in your project. Spring != many XML files This is the minimal xml required for creating a spring 3... Calling a Java Class in PL/SQLCalling a Java class in PL/SQL Create your java class. Make sure the method you want to call from PL/SQL is declared static . From Oracle 8 and higher, you can use the commandline utility loadjava to load your Java class loadjava -user username/password@SID -force -resolve MyPath\MyFile.java Login as SYS to grant privileges to the user Call... |
Enterprise 2.0Oracle’s Optimized Solution for WebCenter 11g – The Reference Architecture.Oracle's Optimized Solution for WebCenter 11g – The Reference Architecture. p { margin-bottom: 0.08in; } Enterprise 2.0-enabled Web portals provide a way for organizations to achieve their goals of improving collaboration and communication, increasing employee productivity, and promoting business agility. But any information submitted to an unsecure Web site is at risk. In addition to... Webcenter and UCM IntegrationWebcenter and UCM integration In WebCenter there are different methods to integrate UCM with your custom applications or WebCenter spaces application. In the document below I will describe different techniques to create application with lots of functionality from the Content Server. The document exist of 2 big parts. In the first part I will discuss the out of the box components... Address your business challenges with Oracle WebCenterAddress your business challenges with Oracle WebCenter Companies in all industries need to provide users with relevant information, bridge information and data silos, and develop applications more rapidly and at lower cost. Most companies face challenges that prevent them from executing on these goals. Provide Relevant Information The amount of data created and stored by... Inter-Portlet Communication With ADF PortletsInter-Portlet Communication With ADF Portlets in Webcenter 11g In a modern Enterprise 2.0 portal you will find the need to let 2 portlets communicate with each other. Because you are working with webcenter, the change is big you also are creating ADF portlets instead of normal JSP portlets. Webcenter currently does not implement the JSR286 standard which describes how to communicate... Fusion middlewareiAS and beyondOracle Internet Application Server, Weblogic Server … and beyond Do you ever wonder what will happen with your Internet Application Server (iAS) investments? Do you get confused about the products like Weblogic Server and JRockit? Do you need to rebuild your applications, Forms or Java, when going to this new platform? What is the impact on licence cost when migrating to... Benefits of migrating your OC4J Oracle Forms to the new 11g Weblogic Server.Benefits of migrating your OC4J Oracle Forms to the new 11g Weblogic Server. Oracle Application Server 11g is not an upgrade from Oracle Application Server 10g. It is a brand new platform. In addition, Oracle Application Server 11g comes with more comprehensive collection of tools than its predecessor. The new application server is a real benefit for small and large IT organisations. ... Oracle Forms: What’s next?Oracle Forms: What's next? With the release in July 2009 of Oracle Fusion Middleware 11 g , including tools such as Oracle Forms 11 g and Oracle Reports 11 g , Oracle customers are looking for guidance on their choice of development tools for existing and future application development. Oracle customers have a considerable... ConributeNewsletterConribute Newsletter Recently we started sending out a newsletter to some of our customers. In our newsletter we want to regularly inform people of the latest Oracle news, usefull technical tips and specific Contribute updates. You can see an example of our newsletter by clicking on the link . Feel free, to subscribe to our newsletter on this page. AreYouTheSmartest 2010AreYouTheSmartest 2010 Every year Oracle provides their partners an overview of the latest 'hot topics' about the Oracle Fusion Middleware product portfolio. This year the following topics were on the agenda : - Layering your enterprise security - Database 11gR2 - Enterprise 2.0 - AYTS_ETL - Enterprise Manager from app to OS - Application Grid 11g For each session there is an... Setting up Webutil for Oracle FormsSetting up Webutil for Oracle Forms What is Webutil While migrating Oracle Forms applications from 6i to 10g, it's possible that you'll face problems on parts of the form that won't work anymore. Oracle Forms 6i are Client based, this means that every form has to be on each client computer in order to work. The functionality that was written in the forms will be executed on the... JavaNumber column as booleanNumber column as boolean When you use an Oracle database, you don't have a boolean type to use in your tables. Usually, you work around this problem by using a numeric column with values 0 and 1. This however could cause some extra programming work when building an application on top of your database. The numbers have to be converted to booleans, and vice versa. Now, in ADF... ADF productivityIncrease your JEE development productivity with Oracle ADF Java EE is a standard, robust, scalable, and secure platform that forms the basis for many of today’s enterprise applications. Java EE provides a set of specifications for building multi-tier applications using the JavaTM language. In the past, there was a direct correlation between the robust nature of an... SoaOracle MagazineLook inside > November/December 2010 |