[Couchdb Wiki] Update of "Getting_started_with_PL_SQL" by JoanTouzet

[Apache Wiki <wi...@apache.org>]

Dear wiki user,

You have subscribed to a wiki page "Couchdb Wiki" for change notification.

The page "Getting_started_with_PL_SQL" has been deleted by JoanTouzet:

https://wiki.apache.org/couchdb/Getting_started_with_PL_SQL?action=diff&rev1=3&rev2=4

Comment:
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=97555310

- Getting started with PL/SQL and the CouchDB API.
  
- = PL/COUCH =
- PLCouch is a simple way to save Oracle-Data in a document based database. With PLCouch, you can create, updet and delete documents, manage Databases.
- 
- == Dependencies ==
-  * http://code.google.com/p/pl-couch/
- 
-  * https://sourceforge.net/projects/pljson/
- 
- == Sample Usage ==
- {{{
- SET SERVEROUTPUT ON SIZE 1000000
- DECLARE
-   --
-   PROCEDURE ASSERTTRUE(B BOOLEAN) AS
-   BEGIN
-     IF(NOT B) THEN RAISE_APPLICATION_ERROR(-20111, 'Test error'); END IF;
-   END;
-   --
-   PROCEDURE ASSERTFALSE(B BOOLEAN) AS
-   BEGIN
-     IF(B) THEN RAISE_APPLICATION_ERROR(-20111, 'Test error'); END IF;
-   END;
-   --
- BEGIN
-   --
-   -- Connect to database
-   PL_COUCH_DB.INIT_DB(HOSTNAME  => :HOST
-                      ,PORT      => :PORT
-                      ,ADMIN     => :admin
-                      ,adminpwd  => :adminpwd);
-   ASSERTTRUE(PL_COUCH_DB.PING_COUCHDB);
-   --
-   DBMS_OUTPUT.PUT_LINE('couchDB-Version:' || PL_COUCH_DB.GET_VERSION);
-   -- Check Database
-   ASSERTTRUE(PL_COUCH_DB.PING_COUCHDB);
-   --
-   databasename := 'test' || TO_CHAR(SYSDATE, 'YYMMDDHH24MISS') || 'x';
-   DBMS_OUTPUT.PUT_LINE('Create Database: ' || databasename);
-   ASSERTTRUE(PL_COUCH_DB.CREATE_DB(DATABASENAME));
-   --
-   jList := PL_COUCH_DB.GET_ALL_DB;
-   --
-   IF jList.count > 0 THEN
-     FOR I in 1 .. jList.count LOOP
-         listElement := jList.get_elem(I);
-         dummy := listElement.getvarchar2(charElement);
-         DBMS_OUTPUT.PUT_LINE('Database: ' || charElement);
-     END LOOP;
-   END IF;
-   --
-   DBMS_OUTPUT.PUT_LINE('Drop Database: ' || databasename);
-   ASSERTTRUE(PL_COUCH_DB.DROP_DB(DATABASENAME));
-   --
- END;
- /
- 
- PROMPT ENDE
- }}}
- More Samples see: http://code.google.com/p/pl-couch/downloads/list
-