Class ::acs::db::oracle

::acs::db::oracle[i] create ...

Support class for backend based on Oracle, i.e., the Oracle dialect of SQL).. This class can be used with the nsdb and the nsdbi drivers of NaviServer.
Defined in packages/acs-tcl/tcl/acs-db-12-procs.tcl

Class Relations

  • class: ::nx::Class[i]
  • superclass: ::acs::db::SQL[i]
  • subclass: ::acs::db::nsdb-oracle[i]

Methods (to be applied on instances)

  • get_all_package_functions (scripted, public)

     <instance of acs::db::oracle[i]> get_all_package_functions \
        [ -dbn dbn ]

    Get all package functions (package name, object name) from Oracle system catalogs. The resulting list contains entries of the form: sqlpackage object {argument_names ... types ... defaulted ... result_type ....} Note that the method processes only the functions and procedures created by the current USER, which is in the default configuration the user "OPENACS". This way, we cover only these functions defined by OpenACS. This has a similar functionality like the "function_args" in PostgreSQL.

    Switches:
    -dbn (optional)

    Testcases:
    No testcase defined.
  • map_function_name (scripted, public)

     <instance of acs::db::oracle[i]> map_function_name sql

    Replace calls to function names in provided SQL (replace "package__object" by "package.object").

    Parameters:
    sql (required)

    Testcases:
    No testcase defined.