Important Announcement

This forum will be discontinued.

The creation of new topics is disabled.

Please open GitHub issues for the corresponding topics/products in the following Trivadis repositories:

A lot of users have already a GitHub account and the management of the issues is better than in this forum. For example, closing a forum topic is never related to a product change. Closing a GitHub issue for an accepted bug means that the bug is fixed. This should simplify the work for all involved parties.

See this blog post for more information.

Thank you for your understanding.

blank
Philipp Salvisberg
@phs
Admin
Trusted Member
Topics: 0 / Replies: 51
Reply
Answer to: Offset/Fetch giving errors

Yes, you're right. That's another parser bug. I've opened a ticket (PLSQLCOP-269). Parse error when using expressions in offset/rowcount in row_limiti...

4 years ago
Forum
Reply
RE: Offset/Fetch giving errors

using an alias works as well. In fact it is required also for the subquery variant. updated post.

4 years ago
Forum
Reply
RE: Offset/Fetch giving errors

opened ticket PLSQLCOP-268

4 years ago
Forum
Reply
Answer to: Offset/Fetch giving errors

Hmm, this looks like a parser bug. Thanks for reporting this. I'll open a ticket. However, It usually does not make sense to use the row_limiting_clau...

4 years ago
Forum
Reply
Answer to: Offset/Fetch giving errors

Can you please provide a full example? Thx

4 years ago
Forum
Reply
Answer to: Code templates corrupt after installation PL/SQL Cop

No, this is not known. I can reproduce it. I use some utPLSQL templates. I've done the following: 1) typed "ut", crtl-tab, selected a template 2) righ...

4 years ago
Forum
Reply
Answer to: Guidelines 1050 vs 7230

In the meantime I wrote the blog post I mentioned before. See . This makes clear that declaring constants in a package specification is okay. The Gui...

4 years ago
Forum
Reply
Answer to: Custom Validator - How to Override Checks and other Questions

I've opened a GitHub issue for the first part of the question and will answer it there. My second question is regarding the license. It says no commer...

4 years ago
Forum
Reply
Answer to: Guidelines 1050 vs 7230

Regarding G-1050 there was a related discussion on GitHub where the guidelines are maintained. Regarding G-7230: If you define constants or variables...

4 years ago
Forum
Reply
Answer to: TVDCC extremely slow

This is really slow. I've changed to the sample directory of tvdcc and run "tvdcc.sh path=.". The result was: Summary:- Total files: 93- Total bytes:...

4 years ago
Forum
Reply
Answer to: java.lang.NullPointerException in XMLIssuePrinterStrategy.endResource

This is related to the other issue. The NPE occurs after reaching the timeout. Something goes wrong during cancelling of the task. That's strange, but...

4 years ago
Forum
Reply
RE: TVDCC extremely slow

Could you please post the result without using the validator parameter? You are currently using TrivadisGuidelines3Plus validator. I do not see if thi...

4 years ago
Forum
Reply
Answer to: table validator

So our question is: is it currently possible create a custom validator on a Create or Alter Table statement? No, not with the PL/SQL validator. There ...

4 years ago
Forum
Reply
Answer to: TVDCC extremely slow

You set the timeout to 10 seconds per file. If you process 10 files and every file gets a timeout then the process is terminated after 1:40 minutes wi...

4 years ago
Forum
Reply
RE: Unexpected recommendations

I agree the the naming of the rule is not optimal. However the reason and the example onmakes it clear. The mode should be set explicitly. See parame...

4 years ago
Forum
Page 1 / 4