Comments (26)
Danieleeee
commented on June 10, 2024
1
from oradew-vscode.
mickeypearce
commented on June 10, 2024
This is a warning. Do you get any additional info if you run same code with SQL Developer or Toad?
from oradew-vscode.
Danieleeee
commented on June 10, 2024
I wasn't looking for more info, but the possibility of highlighting errors in other colors, such as red and yellow. A bit like with the Success message:
from oradew-vscode.
Danieleeee
commented on June 10, 2024
We have a problem matcher like this?
problem-matcher exemple
from oradew-vscode.
Danieleeee
commented on June 10, 2024
If I add a comma in the last procedure parameter, in Toad I have this (PLS-00103):
in oradew this:
from oradew-vscode.
Danieleeee
commented on June 10, 2024
Look this one:
issue 20
from oradew-vscode.
mickeypearce
commented on June 10, 2024
There is already a problem matcher implemented. If you compile your object-file correctly placed in Src folder the problems should be matched. The problems are also parsed if you run file as a script but in your case the sql*plus outputed only "Warning: Package created with compilation errors". Can you try adding show errors ath the end of your script?
from oradew-vscode.
Danieleeee
commented on June 10, 2024
I have this configuration:
{
"compile.warnings": "NONE",
"compile.force": true,
"compile.stageFile": false,
"source.input": ["./Database/**/*.sql","./Database/**/**/*.sql","./Database/**/**/**/*.sql","./Database/**/**/**/**/*.sql"],
"source.encoding": "win1250",
"source.pattern": {
"packageSpec": "./Database/{schema-name}/STOREDS/PKSPEC/{object-name}_h.sql",
"packageBody": "./Database/{schema-name}/STOREDS/PKBODY/{object-name}_b.sql",
"trigger": "./Database/{schema-name}/TRIGGERS/{object-name}.sql",
"typeSpec": "./Database/{schema-name}/TYPES/{object-name}.sql",
"typeBody": "./Database/{schema-name}/TYPE_BODIES/{object-name}.sql",
"view": "./Database/{schema-name}/VIEWS/{object-name}.sql",
"function": "./Database/{schema-name}/STOREDS/FUNC/{object-name}.sql",
"procedure": "./Database/{schema-name}/STOREDS/PROC/{object-name}.sql",
"table": "./Database/{schema-name}/TABS/{object-name}_tab.sql",
"synonym": "./Database/{schema-name}/SYNONYMS/{object-name}.sql",
"apex": "./Database/{schema-name}/APEX/{object-name}.sql"
},
"import.ease": true,
"import.getDdlFunction": "SIU.UTL_GENERATE_ORADEW.getDdl",
"package.input": ["./scripts/*.sql", "./Database/**/*.sql", "./scripts/**/*.sql"],
"package.exclude": ["./scripts/**/+(file|run|test)*.sql"],
"package.output": "./pubblicazione/{schema-name}.sql",
"package.encoding": "win1250",
"package.templating": false,
"test.input": ["./test/**/*.test.sql"],
"version.number": "0.0.1",
"version.description": "Gestione DB",
"version.releaseDate": "2020-01-01"
}and it shows me no errors when I compile the current file. Maybe the settings or the structure of the workspace is wrong
from oradew-vscode.
mickeypearce
commented on June 10, 2024
Please send also the file content (you can ommit most of the body, leave enough to reproduce the error) and the file path.
from oradew-vscode.
Danieleeee
commented on June 10, 2024
Is it possible that since my main folder is called "Database" and not "src", there could be problems?
File path is this: .\Database\SIURETE\STOREDS\PKBODY\RET_PRESE_DEV_b.sql
File content:
CREATE OR REPLACE PACKAGE BODY SIURETE.RET_PRESE_DEV
AS
PROCEDURE INIZIALIZZA_METADATI (
PO_ERR_SEVERITA IN OUT NOCOPY VARCHAR2,
PO_ERR_CODICE IN OUT NOCOPY VARCHAR2,
PO_MESSAGGIO IN OUT NOCOPY VARCHAR2,
P_LINGUAID IN VARCHAR2,
P_OPEID IN VARCHAR2,
P_RUOLOID IN VARCHAR2,
P_SUPERUSER IN VARCHAR2,
PO_EDW_PERMESSI IN OUT NOCOPY XMLTYPE,
pOutputMetadati IN OUT NOCOPY EDW_QBE_API_PCK.tOutputMetadati,
)
IS
kNomePackage CONSTANT VARCHAR2(30) := 'RET_PRESE_DEV';
vProcName VARCHAR2(100);
BEGIN
--
vProcName := 'INIZIALIZZA_METADATI';
--
EXCEPTION
WHEN OTHERS THEN
PO_ERR_SEVERITA := 'F';
PO_ERR_CODICE := SQLCODE;
--
END RET_PRESE_DEV;
/
from oradew-vscode.
mickeypearce
commented on June 10, 2024
Yes, that could be a problem. it should be configurable in theory, but I never tested changing src folder. I will try to reproduce... You tried executing "compile current file", right?
from oradew-vscode.
Danieleeee
commented on June 10, 2024
yes
from oradew-vscode.
mickeypearce
commented on June 10, 2024
And what do you get as an error?
from oradew-vscode.
Danieleeee
commented on June 10, 2024
no error
from oradew-vscode.
mickeypearce
commented on June 10, 2024
Please post a print screen of terminal.
from oradew-vscode.
mickeypearce
commented on June 10, 2024
"Database" instead of "src" shouldn't be a problem. Is it possible that you have a "strange" non latin char in your project name or something similar? (blurred text)
from oradew-vscode.
mickeypearce
commented on June 10, 2024
Probably not related to your problem but:
"source.input": ["./Database/**/*.sql"], should be enough as ** means "any number of levels" in dirs.
from oradew-vscode.
Danieleeee
commented on June 10, 2024
I have updated the configuration.
The problem of error-free compilation remains.
Thanks
from oradew-vscode.
Danieleeee
commented on June 10, 2024
Returning to the issue of errors with sqlplus, is it not possible to highlight the errors even in that situation?
There should always be a task to issue the "run as scrip" command, so the "problem matcher" can be implemented.
from oradew-vscode.
mickeypearce
commented on June 10, 2024
I cannot reproduce this issue, it seems to work for me. Do you still have this problem, @Danieleeee ?
from oradew-vscode.
Danieleeee
commented on June 10, 2024
Yes.
The package runs on the DB but errors are not reported.
I can enter anything and the compilation is always OK
from oradew-vscode.
Danieleeee
commented on June 10, 2024
I use this button:
from oradew-vscode.
Danieleeee
commented on June 10, 2024
If I add shows errors, it works for launch with SQLPlus.
But it remains error-free in the "Compile Current File" method.
Maybe I have to initialize the workspace for it to work (Initialize Workspace)?
from oradew-vscode.
mickeypearce
commented on June 10, 2024
Yes, start fresh with a simpler project path (no blank spaces in project name, etc.) and default workspace configuration.
from oradew-vscode.
Danieleeee
commented on June 10, 2024
Hi, I continue this report because the problem seems to me connected.
Basically I wanted to ask you if it is possible to have error parsing when running a file.sql (f5) as script.
Currently the errors are reported in the output, but it gets lost among the countless lines of output printed.
Being able to highlight the error would save me from having to do an "error" find on all the execution output.
this is an example:
HMS_PARAMETRI
!!! DUP VAL tabella HMS_PARAMETRI: ATTIVA_DEL_434_17
PL/SQL procedure successfully completed.
HMS_ANAGRAFICA_MAPPATURE
!!! DUP VAL tabella HMS_ANAGRAFICA_MAPPATURE: GM_434_17
PL/SQL procedure successfully completed.
HMS_ANAGRAFICA_TPRESTAZIONE
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: CMG1_0200
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: CMG1_0201
PL/SQL procedure successfully completed.
HMS_ANAGRAFICA_MAPPATURE_TP
!!! DUP VAL tabella HMS_ANAGRAFICA_MAPPATURE_TP: GM_434_17 CMG1_0200
!!! DUP VAL tabella HMS_ANAGRAFICA_MAPPATURE_TP: GM_434_17 CMG1_0201
PL/SQL procedure successfully completed.
HMS_SEQUENZA_FLUSSI
!!! DUP VAL tabella HMS_SEQUENZA_FLUSSI: GM_434_17 - CMG1 - 0200 1
!!! DUP VAL tabella HMS_SEQUENZA_FLUSSI: GM_434_17 - CMG1 - 0201 2
PL/SQL procedure successfully completed.
HMS_CSV_MAPPING
-----------------------------------------------------
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 01
<ROOT>/COD_SERVIZIO
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 02
<ROOT>/COD_FLUSSO
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 03
IdentificativiRichiesta/PIVA_DISTRIBUTORE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 04
IdentificativiRichiesta/PIVA_GESTORE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 05
IdentificativiRichiesta/CP_GESTORE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 06
DataRiferimentoCertificazione/MESE_TRASMISSIONE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 07
DataRiferimentoCertificazione/GIORNO_TRASMISSIONE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 08
FileDisponibile/IDENTIFICATORE_FILE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 09
FileDisponibile/DIMENSIONE_FILE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 10
FileDisponibile/TIPO_FILE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0200 - 11
FileDisponibile/DIGEST
-----------------------------------------------------
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 01
<ROOT>/COD_SERVIZIO
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 02
<ROOT>/COD_FLUSSO
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 03
IdentificativiRichiesta/PIVA_DISTRIBUTORE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 04
IdentificativiRichiesta/PIVA_GESTORE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 05
IdentificativiRichiesta/CP_GESTORE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 06
DataRiferimentoCertificazione/MESE_TRASMISSIONE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 07
DataRiferimentoCertificazione/GIORNO_TRASMISSIONE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 08
FileDisponibile/IDENTIFICATORE_FILE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 09
FileDisponibile/DIMENSIONE_FILE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 10
FileDisponibile/TIPO_FILE
!!! DUP VAL tabella HMS_CSV_MAPPING: GM_434_17 - CMG1 0201 - 11
FileDisponibile/DIGEST
PL/SQL procedure successfully completed.
Parametrizzazione MISURE
HMS_PARAMETRI
!!! DUP VAL tabella HMS_PARAMETRI: ATTIVA_DEL_185_20
PL/SQL procedure successfully completed.
HMS_ANAGRAFICA_MAPPATURE
INS tabella HMS_ANAGRAFICA_MAPPATURE. ERRORE: -1400 -- ORA-01400: cannot insert
NULL into ("SIUHERMES"."HMS_ANAGRAFICA_MAPPATURE"."XSDPATH")
PL/SQL procedure successfully completed.
HMS_ANAGRAFICA_TPRESTAZIONE
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_TML
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_TGL
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_RML
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_RGL
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_TMV
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_RMV
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_SWG1
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_FUI
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_FDD
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_RSL
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_TAL
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_TAS
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_TAV
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_D01
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_D02
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_R01
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_A40
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_S40
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_R40
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_A01
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_A02
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_S02
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_V01
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_M01
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_V02
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_SM1
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_SM2
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD2
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD3
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD4
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD5
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_D01R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_D02R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_R01R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_A40R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_S40R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_R40R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_A01R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_A02R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_S02R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_V01R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_M01R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_V02R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_SM1R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_SM2R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD2R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD3R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD4R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_AD5R
!!! DUP VAL tabella HMS_ANAGRAFICA_TPRESTAZIONE: MISURE_IGMG
PL/SQL procedure successfully completed.
Commit complete.
No errors.
Even putting the "show err" command at the end of the script, the final output is "No errors"
from oradew-vscode.
Danieleeee
commented on June 10, 2024
can you make problem matcher multilingual?
"problemMatchers": [
{
"name": "oracle-plsql",
"owner": "external",
"fileLocation": [
"absolute"
],
"pattern": [
{
"regexp": "^.*\\$(.*)$",
"file": 1
},
{
"regexp": "^(\\d+)\\/(\\d+)\\s+(WARNING|ERROR|INFO)\\s+(.*)$",
"line": 1,
"column": 2,
"severity": 3,
"message": 4,
"loop": true
}
],
"background": {
"activeOnStart": true,
"beginsPattern": "^.*Starting compilation...$",
"endsPattern": "Compilation complete."
}
}
],
when I have errors in Italian it writes ERRORE and not ERROR
from oradew-vscode.
Related Issues (20)
- Run as Script hangs for a few minutes HOT 3
- Windows econding UTF8 problem HOT 42
- Compile error "ERROR ORA-06550: line 3, column 40:" HOT 8
- problems importing packages from the DB HOT 3
- Generate: "output" doesn't work
- Extension causes high cpu load HOT 1
- Encoding error when importing the selected object HOT 8
- Displaying umlauts in terminal output
- Encoding problem in SQL-Statements HOT 3
- dbms_metadata.get_ddl does not work when used in UTL_GENERATE_ORADEW HOT 3
- Initialize Workspace not working HOT 8
- Oracle wallet authentication compatibility, userless & passwordless HOT 9
- Error while trying to retrieve text for error ORA-01804 HOT 5
- Drop support for sqlplus, sqlcl Liquibase ci/cd HOT 8
- Support latest version of node HOT 6
- Generating a source from a database HOT 5
- Create source from a non-DEV env
- Problem importing when object has "SQL" in the name HOT 1
- problems connecting to oracle database (proxy authentication) HOT 7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from oradew-vscode.