GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Using Oracle Editions Based - EBR · Issue #224 · utPLSQL/utPLSQL-cli

Using Oracle Editions Based - EBR #224

New issue
Copy link
New issue
Copy link
Open
Open
Using Oracle Editions Based - EBR#224
Copy link

Description

@milheiros
milheiros
opened on Jan 31, 2024
Issue body actions

Hi eveyone,

It is possible to connect to DB when calling utplsql-cli run command using a specific Edition name/number?
Something like this:

utplsql run username/password@service EDITION=ora$base -source_path=Packages -test_path=UnitTestPackages --failure-exit-code=0 -f=ut_coverage_cobertura_reporter -o=cobertura_reporter.xml -f=ut_coverage_sonar_reporter -o=coverage.xml -f=ut_sonar_test_reporter -o=test_results.xml

Activity

  1. felipebz commented on May 19, 2024

    @felipebz
    felipebz
    on May 19, 2024
    More actions

    As far as I know, there's no explicit support for EBR in utPLSQL-cli, but the Oracle JDBC Driver includes a property that can be set to specify the edition.

    In Windows cmd:

    set JAVA_OPTS=-Doracle.jdbc.editionName=MY_EDITION
    utplsql run (...)
    

    In Linux:

    export JAVA_OPTS=-Doracle.jdbc.editionName=MY_EDITION
    utplsql run (...)
    
    Reacted by Jacek Gębal and milheiros
  2. jgebal commented on May 20, 2024

    @jgebal
    jgebal
    on May 20, 2024
    Member
    More actions

    Yes, @felipebz is correct, utPLSQL-cli does not provide any setting for editions.
    The tup with JAVA_OPTS is a really neat workaround for the missing feature.

    Reacted by milheiros
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.