Skip to content
This repository has been archived by the owner on Apr 5, 2019. It is now read-only.

PL/SQL compilation errors not shown after compilation #81

Open
AlainVimmer opened this issue Sep 2, 2017 · 0 comments
Open

PL/SQL compilation errors not shown after compilation #81

AlainVimmer opened this issue Sep 2, 2017 · 0 comments

Comments

@AlainVimmer
Copy link

AlainVimmer commented Sep 2, 2017

Hello Alex,

I created in the database a function called "F" with a syntax error within.
After I open an Oracle function with Vorax Explorer, and hit "leader"c to compile it, it does show "Warning: Function created with compilation errors." but does not open the quickfix window to list errors.
I am using vorax 4.3.55 on VIM 8 on Windows 7, compiled with ruby 2.0.

in Vorax.log shown below, the SQL query to retrieve error looks for a function called 'CREATED' (which does not exist) instead of function "F" (which exists but is invalid).

I tried with other functions or packages and it does the same thing.
Any idea as to why this is happening ?
Thank you,
Alain


2017-09-02 22:35:32.859 [vim] - PLSQL GetErrros: modules=[{'module': 'CREATED', 'owner': 'ALAINADM', 'defined_at': 2, 'type': ''}]

2017-09-02 22:35:32.859 [vim] - vorax#sqlplus#Query command='select line, position, text, owner, name, type from all_errors where (owner = ''ALAINADM'' and name = ''CREATED'');'

2017-09-02 22:35:32.859 [rby] - default_convertor=nil

2017-09-02 22:35:32.859 [rby] - exec: command=[
select line, position, text, owner, name, type from all_errors where (owner = 'ALAINADM' and name = 'CREATED');
]
params={:prep=>"store set M:\bin\VIAF35A.tmp.opts replace\nset markup html on\nset linesize 10000\nset define "&"\nset pause off\nset termout on", :post=>"@m:\bin\VIAF35A.tmp.opts"}

2017-09-02 22:35:32.859 [rby] - sent to sqlplus: set markup html off

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant