package-procs-oracle.xql

  • last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between oracle and postgres codebase

  1. … 2 more files in changeset.
Reduce divergency between oracle and postgres codebase, reduce query replication using api

  1. … 3 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
.xql overhaul:

- removed misleading sql-statements from db_* calls, which were

ignored due .xql files

- removed bug where same query name was used in a single proc

with different intended sql queries, but the same was picked

up from the .xql file due to the name

- removed multiple entries of same query name from .xql files

(e.g. the entry "package_create_attribute_list.select_type_info" was

7 (!!!) times in a single .xql file)

- removed redundant queries for unsupported versions of the dbms

- added missing xql entries for db-backends, where other db-specific

queries exists (e.g. added an entry to -oracle.xql, where an entry

existed in -postgres.xql)

  1. … 70 more files in changeset.
- remove unneeded xql statements

  1. … 12 more files in changeset.
Merged 5.5.1 to HEAD

  1. … 181 more files in changeset.
package_exec_plsql didn't work if the sql proc being called has a parameter

named "package_name"...

  1. … 2 more files in changeset.
bugfix: fixing bug #2399, wrong query labeling in xql files

  1. … 1 more file in changeset.
Bug #2274: My removal of "upper()" some time back broke some things, hmmm, put it back

in.

  1. … 1 more file in changeset.
Fixed a CVS merge error from 5.1 ...

  1. … 1 more file in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
Misspelled the query name for calling an Oracle function in package_exec_plsql...

Fixed package_exec_plsql so it works with Oracle procedures as well as

functions (PG only has functions so was working fine for all cases)

  1. … 2 more files in changeset.
Made package_exec_plsql work for Oracle procedures ...

  1. … 2 more files in changeset.
Fixed get_pageflow_structure to correctly label the index_redirect_url as

"Home".

  1. … 2 more files in changeset.
Fixed new package_exec_lsql proc and also fixed bug involving funcs which

have parameters named "key" etc by renaming internal vars "__key" etc as

needed ...

  1. … 2 more files in changeset.
Added "package_exec_plsql" which, like "package_instantiate_object", allows

one to call PLSQL from Tcl, which reduces the need for oracle/pg-specific

XQL files.

  1. … 3 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
Reverse a change introduced in rev 1.4 which breaks the group-new

admin page

updated package procs and relation procs to provide better handling of

additional variables. This *may* cause some things to break, and the added

functionality is not yet PG-compatible. It will be soon, though. (ben)

  1. … 2 more files in changeset.
Port group-type maintenance (no attributes yet)

  1. … 14 more files in changeset.
Port queries/query extractor output

  1. … 180 more files in changeset.
A small contribution to port it

    • -0
    • +72
    ./package-procs-oracle.xql
  1. … 33 more files in changeset.