Oracle的PL / SQL实用程序

This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere.

Generate PDF files using PL/SQL

• http://technology.amis.nl/blog/8650/as_pdf-generating-a-pdf-document-with-some-plsql
• http://www.erasme.org/PL-FPDF,1337?lang=en
• http://ora-00001.blogspot.com/2009/10/free-pdf-package-for-plsql.html
• PDFGEN_PKG
• PDFGEN_UTIL_PKG

Generate Excel files using PL/SQL

• http://technology.amis.nl/blog/10995/create-an-excel-file-with-plsql
• http://www.jasonsdevelopercorner.com/?page_id=8
• https://xml-spreadsheet.samplecode.oracle.com/
• http://sanjeev-oracle-world.blogspot.com/2007/06/create-excel-workbook-by-plsql-code.html
• http://matzberger.de/oracle/spreadsheet-en.html
• http://www.protalk.in/oracle/plsql-tips-package-for-exporting-data-to-excel/
• SYLK_UTIL_PKG

Generate RTF files using PL/SQL

• http://monkeyonoracle.blogspot.com/2009/07/dynamic-rtf-documents-revisited.html

Working with Office 2007 (OOXML) files using PL/SQL

• http://ora-00001.blogspot.com/2011/02/working-with-office-2007-ooxml-files.html
• http://technology.amis.nl/blog/8090/parsing-a-microsoft-word-docx-and-unzip-zipfiles-with-plsql
• OOXML_UTIL_PKG

Zip and unzip files using PL/SQL

• http://technology.amis.nl/blog/7626/utl_compress-gzip-and-zlib
• ZIP_UTIL_PKG

Generate and parse CSV files using PL/SQL

• http://ora-00001.blogspot.com/2010/04/select-from-spreadsheet-or-how-to-parse.html
• CSV_UTIL_PKG

Generate and parse RSS feeds using PL/SQL

• http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-one.html
• http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-two.html
• RSS_UTIL_PKG

Generate JSON using PL/SQL

• http://ora-00001.blogspot.com/2010/02/ref-cursor-to-json.html
• JSON_UTIL_PKG

Parse JSON using PL/SQL

• http://sourceforge.net/projects/pljson/
• http://reseau.erasme.org/pl-sql-library-for-JSON?lang=en

Transfer files (FTP) using PL/SQL

• http://www.oracle-base.com/articles/misc/FTPFromPLSQL.php
• FTP_UTIL_PKG

Send email (SMTP) using PL/SQL

• http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
• http://download.oracle.com/docs/cd/E10513_01/doc/apirefs.310/e12855/apex_mail.htm
• MAIL_UTIL_PKG

Receive email (POP3) using PL/SQL

• POP3_UTIL_PKG

Receive email (POP3 and IMAP) using PL/SQL (and Java)

• http://plsqlmailclient.sourceforge.net/

Integrate with Google services (Google Maps, Google Calendar, Google Translate) using PL/SQL

• http://ora-00001.blogspot.com/2009/12/using-google-translate-from-plsql.html
• GOOGLE_AUTH_PKG
• GOOGLE_CALENDAR_PKG
• GOOGLE_MAPS_PKG
• GOOGLE_TRANSLATE_PKG

Integrate with Amazon web services (Simple Storage Service S3) using PL/SQL

• http://ora-00001.blogspot.com/2011/03/amazon-s3-api-for-plsql.html
• http://jastraub.blogspot.com/2011/01/building-amazon-s3-client-with.html
• AMAZON_AWS_AUTH_PKG
• AMAZON_AWS_S3_PKG

Integrate with PayPal web services

• PAYPAL_UTIL_PKG

Integrate with Twitter using PL/SQL

• http://oratweet.com/

Call SOAP and REST web services using PL/SQL

• http://jastraub.blogspot.com/2008/06/flexible-web-service-api.html
• https://flex-ws-api.samplecode.oracle.com/
• http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/apex_web_service.htm#BABFFDEH
• http://ora-00001.blogspot.com/2009/07/calling-soap-web-service-from-plsql-by.html
• SOAP_CLIENT_UTIL_PKG
• T_SOAP_ENVELOPE

Publish SOAP web service using PL/SQL

• http://ora-00001.blogspot.com/2011/01/soap-server-in-plsql.html
• SOAP_SERVER_PKG

Publish REST web services using PL/SQL

• http://ora-00001.blogspot.com/2009/07/creating-rest-web-service-with-plsql.html
• http://www.oracle-base.com/articles/misc/XMLOverHTTP.php

Regular expressions using PL/SQL

• REGEXP_UTIL_PKG

String, date and math utilities

• DATE_UTIL_PKG
• MATH_UTIL_PKG
• STRING_UTIL_PKG

SQL utilities

• SQL_BUILDER_PKG
• SQL_UTIL_PKG

XML utilities

• http://ora-00001.blogspot.com/2011/02/display-any-xml-as-clickable-tree-using.html
• XML_BUILDER_PKG
• XML_DATASET_PKG
• XML_STYLESHEET_PKG
• XML_UTIL_PKG

File utilities

• FILE_UTIL_PKG

HTTP utilities

• HTTP_UTIL_PKG

Encryption and security utilities

• CRYPTO_UTIL_PKG

Logging and debugging utilities

• https://logger.samplecode.oracle.com/
• http://sourceforge.net/projects/log4plsql/
• http://sourceforge.net/projects/ilo/
• DEBUG_PKG

Generating test data and random bits using PL/SQL

• http://ora-00001.blogspot.com/2011/02/generating-test-data-using-plsql.html
• RANDOM_UTIL_PKG

PL/SQL Web Toolkit (OWA) utilities

• OWA_UTIL_PKG

Web Gateways for PL/SQL

• http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm
• http://download.oracle.com/docs/cd/B14099_19/web.1012/b14010/toc.htm
• http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html
• http://code.google.com/p/thoth-gateway/
• http://sourceforge.net/projects/dbprism/
• http://oss.oracle.com/projects/mod_owa/dist/documentation/modowa.htm

jQGrid Integration Kit for PL/SQL and Apex

• http://ora-00001.blogspot.com/2010/03/jqgrid-integration-kit-for-plsql-and.html
• http://code.google.com/p/jqgrid-for-plsql/

Application Express APIs

• http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/toc.htm
• APEX_UTIL_PKG

Miscellaneous utilities and demos

• http://www.toadworld.com/Portals/0/stevenf/demo.zip
• http://www.toadworld.com/ORACLE/StevenFeuersteinsPLSQLObsession/tabid/153/Default.aspx

PL/SQL Frameworks

• http://sourceforge.net/projects/plsqlframestart/
• http://www.toadworld.com/Freeware/PLVisionFreeware/tabid/687/Default.aspx

PL/SQL Wrappers for Java

• http://sourceforge.net/projects/oracle-jutils/

Unit Testing Frameworks for PL/SQL

• http://sourceforge.net/projects/utplsql/
• http://code.google.com/p/pluto-test-framework/

Documentation Generators (JavaDoc-style)

• http://sourceforge.net/projects/plsqlutils/

评论

2 楼 wuhuizhong 2011-11-19  

Publish SOAP web service using PL/SQL:
    Download the source code(http://code.google.com/p/plsql-utils/downloads/list)
    Modify the package body to suit your environment (particularly the g_schema_name constant, and the is_whitelisted function)
    Install the package into your schema
    If you want to run the package through the Apex DAD, remember to grant execute on soap_server_pkg to anonymous (on EPG) or apex_public_user (on mod_plsql), and modify the request validation function (wwv_flow_epg_include_mod_local) as appropriate. Create a synonym if you don't want to include the schema name in the URL.
    Use a SOAP client such as Web Service Studio or SoapUI and navigate to http://your-server/dad-name/soap_server_pkg.wsdl?s=your_package_name

1 楼 lffsonic 2011-07-12  

thinks,this's  good demos for me to learn oracle