OpenACS / openacs-4 / packages / acs-content-repository / sql / oracle

packages-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 12:40
Commits this week: 0
Total Lines of Code (LoC): 1,813
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 21 Feb 2022
7:20 pm

gustafn

Fixes for Oracle 19c: made set_live_revision compatible with postgres version

Options
    • -2
    • +3
    ./packages-create.sql
  2. … 1 more file in changeset.
Sunday 13 Feb 2022
12:46 pm

gustafn

More fixes for Oracle 19c in essential packages

in essence, this fixes

- package content_item

- package content_folder

with the following errors popping at at installation:

Errors for PACKAGE BODY CONTENT_FOLDER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

76/11 PLS-00323: subprogram or cursor 'COPY' is declared in a package

specification and must be defined in the package body

Errors for PACKAGE BODY CONTENT_ITEM:

LINE/COL ERROR

-------- -----------------------------------------------------------------

22/10 PLS-00323: subprogram or cursor 'NEW' is declared in a package

specification and must be defined in the package body

40/1 PL/SQL: Item ignored

67/38 PLS-00382: expression is of wrong type

275/11 PLS-00323: subprogram or cursor 'SET_LIVE_REVISION' is declared

in a package specification and must be defined in the package

body

DRG-10595: ALTER INDEX CR_REV_ATTRIBUTE_INDEX failed

DRG-11000: invalid keyword SYNC

DRG-10595: ALTER INDEX CR_REV_CONTENT_INDEX failed

DRG-11000: invalid keyword SYNC

Options
    • -4
    • +6
    ./packages-create.sql
  2. … 2 more files in changeset.
Saturday 10 Aug 2019
8:05 pm

gustafn

improve spelling

Options
    • -1
    • +1
    ./packages-create.sql
  2. … 35 more files in changeset.
Wednesday 11 Apr 2018
11:35 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./packages-create.sql
  2. … 31 more files in changeset.
Tuesday 27 Mar 2018
1:17 pm

hectorr

Fix typos

Options
    • -4
    • +4
    ./packages-create.sql
  2. … 42 more files in changeset.
Sunday 24 Dec 2017
2:03 pm

gustafn

fix typos

Options
    • -3
    • +3
    ./packages-create.sql
  2. … 14 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -9
    • +9
    ./packages-create.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
4:53 pm

gustafn

Fix spelling errors

Options
    • -9
    • +9
    ./packages-create.sql
  2. … 49 more files in changeset.
Sunday 20 Jan 2008
5:19 pm

donb

Rolled back abortive attempt to substitute dbms_log stuff for java

Options
    • -0
    • +50
    ./packages-create.sql
  2. … 4 more files in changeset.
Monday 17 Sep 2007
2:58 pm

maltes

Got rid of reliance on Java for Oracle. Removed unused old functions. Hopefully someone else can help with a fresh install test as well

Options
    • -50
    • +0
    ./packages-create.sql
  2. … 5 more files in changeset.
Thursday 05 Oct 2006
7:04 pm

emmar

Fix #3008: remove duplicated drop_type procedure, added missing param in proc specification and correct upgrade script

Options
    • -2
    • +2
    ./packages-create.sql
  2. … 2 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -1
    • +7
    ./packages-create.sql
  2. … 721 more files in changeset.
Monday 16 Jan 2006
1:17 am

donb

Fixed 5.1->5.2 upgrade, all content repository tests now pass.

Options
    • -1
    • +1
    ./packages-create.sql
  2. … 6 more files in changeset.
Tuesday 05 Jul 2005
6:33 pm

donb

Further fixing of Timo's use of refresh_trigger

Options
    • -0
    • +6
    ./packages-create.sql
  2. … 1 more file in changeset.
Saturday 12 Mar 2005
8:45 pm

andrewg

Bugfix.

Options
    • -1
    • +1
    ./packages-create.sql
  2. … 1 more file in changeset.
Thursday 24 Feb 2005
2:32 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

Options
    • -0
    • +2
    ./packages-create.sql
  2. … 321 more files in changeset.
Monday 31 Jan 2005
8:29 am

timoh

fixed some upgrade scripts for oracle

Options
    • -2
    • +5
    ./packages-create.sql
  2. … 7 more files in changeset.
Tuesday 18 Jan 2005
5:35 pm

andrewg

Added missing comma in content_revision package definition.

Options
    • -1
    • +1
    ./packages-create.sql
Thursday 13 Jan 2005
2:54 pm

jeffd

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

Options
    • -0
    • +1
    ./packages-create.sql
  2. … 2275 more files in changeset.
Friday 03 Sep 2004
5:58 pm

tracya

filestorage was displying the ugly filename instead of the pretty title for the main entry; also wasn't updating the filename to the newest upload (still need to ask DaveB about getting the links to work with the latest upload filename

Options
    • -1
    • +2
    ./packages-create.sql
  2. … 7 more files in changeset.
Wednesday 02 Jun 2004
12:54 am

donb

Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

Options
    • -2
    • +2
    ./packages-create.sql
  2. … 25 more files in changeset.
Wednesday 26 May 2004
8:50 pm

donb

Further fixing of bug #1858

Options
    • -2
    • +2
    ./packages-create.sql
  2. … 3 more files in changeset.
Friday 09 Apr 2004
4:00 pm

andrewg

various bug fixes for package_id, title addition to acs_objects

Options
    • -2
    • +2
    ./packages-create.sql
  2. … 4 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -8
    • +17
    ./packages-create.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -17
    • +8
    ./packages-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -8
    • +17
    ./packages-create.sql
  2. … 96 more files in changeset.
Saturday 24 Jan 2004
6:54 pm

daveb

Fix content_item.move and content_folder.move

Options
    • -1
    • +3
    ./packages-create.sql
  2. … 2 more files in changeset.
Friday 23 Jan 2004
6:14 am

daveb

More small fixes with misplaced commas etc.

Options
    • -7
    • +7
    ./packages-create.sql
  2. … 3 more files in changeset.
5:39 am

daveb

Fix typos.

Options
    • -1
    • +1
    ./packages-create.sql
5:25 am

daveb

Adding optional name for content_folder.copy. Adding new package definitions

for changes in procedures.

Options
    • -7
    • +14
    ./packages-create.sql
  2. … 1 more file in changeset.