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 — Improve error handling when no utPLSQL is installed · Issue #64 · utPLSQL/utPLSQL-SQLDeveloper

Improve error handling when no utPLSQL is installed #64

New issue
Copy link
New issue
Copy link
Closed
Closed
Improve error handling when no utPLSQL is installed#64
Copy link
Assignees
PhilippSalvisberg
Labels
enhancement
Milestone
v1.1.0

Description

@PhilippSalvisberg
PhilippSalvisberg
opened on Jul 11, 2019
Issue body actions

In version < 1.0.0 the worksheet reporter was started, even if no utPLSQL was installed in the database. In that case the user got the following error in the script output:

ORA-06550: line 1, column 57:
PLS-00201: identifier 'UT.RUN' must be declared
ORA-06550: line 1, column 57:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

This was good.

Starting with version 1.0.0 the realtime reporter is the default. When utPLSQL is not installed, nothing happens. Based on the statement log, it's clear that the ut.version statement fails.

I see two options for a user feedback.

a) an alert message informing the user, that utPLSQL is not installed
b) run the worksheet reporter as in previous versions and let the user figure out what the message means.

Activity

  1. PhilippSalvisberg
    added
    enhancement
    on Jul 11, 2019
  2. PhilippSalvisberg
    added this to the v1.1.0 milestone on Jul 11, 2019
  3. PhilippSalvisberg
    self-assigned this
    on Jul 11, 2019

  4. PhilippSalvisberg commented on Jul 13, 2019

    @PhilippSalvisberg
    PhilippSalvisberg
    on Jul 13, 2019
    MemberAuthor
    More actions

    I decided to go for option b). It's simpler to implement and it gives the user a feedback.

  5. PhilippSalvisberg
    added a commit that references this issue on Jul 13, 2019

    Merge pull request #68 from PhilippSalvisberg/feature/issue_64_no_utp…

    e8130c6
  6. PhilippSalvisberg
    closed this as completedon Jul 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @PhilippSalvisberg
    PhilippSalvisberg

Labels

enhancement

Type

No type

Projects

No projects

    Milestone

    • v1.1.0

    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.