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

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

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

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.

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

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.

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.

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.

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.