Other Databases

Several databases have implemented PL/SQL compatibility layers and so may possibly contain PLDoc.

Currently, these databases are known to support PL/SQL:-

In order to allow PLDoc to work, 2 things are required:-

  • JDBC connection
  • Access to source code (preferably with comments)

This can be accomplished for each database type by specifying:-

  • database specific JDBC JAR files in the CLASSPATH
  • possible libraries in the PATH, LD_LIBRARY_PATH or DYLD_LIBRARY_PATH paths
  • -driver JDBC driver class
  • -url JDBC URL specifying the database to connect to
  • -getmetadata - a callable statement taking the same parameters as Oracle's DBMS_METADATA.GET_DDL
  • -returntype - an integer corresponding to the java.sql.types constant for the object type returned by getmetadata, typically 12 (VARCHAR2) or 2005 (CLOB)

Typical values for each database type are shown below:

Database TypeVerified?JAR files-driver-url-returntype-getmetadataNotes
TimesTen 11.2.1 directYttjdbc6.jar ttjdbc5.jarcom.timesten.jdbc.TimesTenDriverjdbc:timesten:direct:plsqldb12"' ? = call PLS.GET_SOURCE( ? , ? , ? , ? , ? , ? ) '"This JDBC-ODBC driver also requires $OTT_HOME/lib specified in the appropriate PATH, LD_LIBRARY_PATH, or DYLD_LIBRARY_PATH
TimesTen 11.2.2 directYttjdbc6.jar ttjdbc5.jarcom.timesten.jdbc.TimesTenDriverjdbc:timesten:direct:plsqldb2005 (default)"' ? = call PLS.GET_SOURCE_LOB( ? , ? , ? , ? , ? , ? ) '"also requires $OTT_HOME/lib in PATH, LD_LIBRARY_PATH, or DYLD_LIBRARY_PATH
TimesTen 11.2.* clientYttjdbc6.jar or ttjdbc5.jarcom.timesten.jdbc.TimesTenDriver"jdbc:timesten:client: TT_SERVER=server_host_name; TT_SERVER_DNS=Server_DSN; TCP_PORT=server_port"12"' ? = call PLS.GET_SOURCE( ? , ? , ? , ? , ? , ? ) '"ditto
DB2 Express 9.7.5 local databaseYdb2jcc4.jar db2jcc_license_cu.jarcom.ibm.db2.jcc.DB2Driverjdbc:db2://host:port/db2005 (default)"'BEGIN ? := DB2INST1.GET_SOURCE_LOB( ? , ? , ? , ? , ? , ? ); END;'"
DB2 Express 9.7.5 local databaseYdb2jcc4.jar db2jcc_license_cu.jarcom.ibm.db2.jcc.DB2Driverjdbc:db2:db2005 (default)" "BEGIN SELECT text INTO ? FROM dba_source WHERE type = ? AND name = ? AND owner = ? AND ? LIKE '%' AND ? LIKE '%' AND ? LIKE '%' ; END; ""
EnterpriseDB EDB JDBCNedb-jdbc14.jarcom.edb.Driverjdbc:edb://host:port/database12"' ? = call GET_SOURCE( ? , ? , ? , ? , ? , ? ) '"
EnterpriseDB Postgres JDBCYpostgresql-[server version].[buildnumber].jdbcorg.postgresql.Driverjdbc:postgresql://host:port/database12"' ? = call GET_SOURCE( ? , ? , ? , ? , ? , ? ) '"