Forum OpenACS Development: Re: LORS ORACLE port Issues

Collapse
Posted by Dave Bauer on
I will write up all the new work on LORS in the wiki in the next few days. I am on vacation so it might be a little while.

Mainly we are colsolidating the user interface code between lorsm and lors-central so the same learning object management user interface between lorsm and lors-central.

Collapse
Posted by Mario Aguado on

Thanks Dave,

ORACLE have a limit of 30 characters for identifiers. I started three days ago to migrate LORS to ORACLE. These objects has more 30 characters or another issues:

  • Package view:
    • views table have a problem when I compile PL/SQL and insert data.
    • colunm views in views table. I cannot reference to it in PL/SQL code.
  • Package LORS
    • File: lors-imsmd-create.sql
      • Sequence: ims_md_life_cycle_contrib_entity_seq
      • Table: ims_md_life_cycle_contrib_entity
      • Sequence: ims_md_metadata_contrib_entity_seq
      • Sequence: ims_md_technical_requirement_seq
      • Sequence: ims_md_classification_taxpath_seq
      • Sequence: ims_md_classification_taxpath_taxon_seq
      • Table: ims_md_classification_taxpath_taxon
      • Sequence: ims_md_classification_keyword_seq
  • Package LORSM
    • File: lorsm-create.sql
      • Table: lorsm_course_presentation_formats

I'm on vacances last week, but the second week on July return. My deadline to finish to port is september and we want to put it in production in october.

I'm working on release dotlrn2.2b2 file, but I see last changes in the CVS HEAD and update my files.