Features

As told previously, tje project is organized by packages, all owned by OJUTIL user. For each package, you should be able to perform actions from a simple sqlplus* session within a single line of code.

Packages

For each package, have a look at the screenshots to make your own opinion (a lot of screenshots are based on sqlplus* sessions to sho you that everything can simply be done within a very few lines of sql code.

JDBMS_LOB

The JDBMS_LOB package

The API of this package talks by itself. Indeed a test file is provided in test_JDBMS_LOB.sql

JDBMS_CHECKSUM

The JDBMS_CHECKSUM package

The API of this package talks by itself. Indeed a test file is provided in test_JDBMS_CHECKSUM.sql

JDBMS_MIMETYPES

The JDBMS_MIMETYPES package

The API of this package talks by itself. Indeed a test file is provided in test_JDBMS_MIMETYPES.sql

JDBMS_COMPRESS

The JDBMS_COMPRESS package

The API of this package talks by itself. Indeed a test file is provided in test_JDBMS_COMPRESS.sql

For LZMA functions, default command line parameters are provided if you want to deal in a simple way with compressing/uncompressing BLOBS that you can open with 7zip console. To use custom command lines, have a look at the switches :

                            <e|d>
                            e: encode
                            d: decode

                            Switches :

                            -a{N}:  set compression mode - [0, 1], default: 1 (max)
                            -d{N}:  set dictionary - [0,28], default: 23 (8MB)
                            -fb{N}: set number of fast bytes - [5, 273], default: 128
                            -lc{N}: set number of literal context bits - [0, 8], default: 3
                            -lp{N}: set number of literal pos bits - [0, 4], default: 0
                            -pb{N}: set number of pos bits - [0, 4], default: 2
                            -mf{MF_ID}: set Match Finder: [bt2, bt4], default: bt4
                            -eos:   write End Of Stream marker
                        

For more details on how to use LZMA functions, have a look a test_JDBMS_COMPRESS.sql for a quick jumpstart.

JDBMS_XMPP

The JDBMS_XMPP package

The API of this package talks by itself. It is an enhanced version of my first XMPP package (see oracle-xmpp). It will have more functionalities and better behavior, as well as better designed functions. No 1.4 JDK backport will be possible due to exclusive use of latest Smack API. test_JDBMS_XMPP.sql

JDBMS_JACKSUM

The JDBMS_XMPP package

This package wrapps calls to the well known JackSum library. It is useful to compute a large variety of checksums. I have implemented direct checskum computations on files from sql, but also direct checksum computation on BLOBS.

You can then compute CRC, etc... generate edk url (files only). Have a look at test_JDBMS_JACKSUM.sql for more examples.

JDBMS_FILESYSTEM

The JDBMS_FILESYSTEM package

This package is useful to interact with the Database OS files.

You can list directory contents, etc... Have a look at test_JDBMS_FILESYSTEM.sql and to screenshots for more examples.

JDBMS_TWITTER

The JDBMS_TWITTER package

This package is useful to interact with Twitter.

For now, you can send messages and ping the Twitter server. Additional features will soon come. Have a look at test_JDBMS_TWITTER.sql and to screenshots for more examples.

JDBMS_QRCODE

The JDBMS_QRCODE package

This package is useful to deal with QrCodes.

For now, the encoding is performed thanks to Google Charts. Additional features will soon come. Have a look at test_JDBMS_QRCODE.sql and to screenshots for more examples.