New version of texType plugin

[softema.com]

texType plugin 2.0 has been released

New features:
- SQL reference (DDL, DML statements visual creation)

- PL/SQL offline syntax check (does not require connection to DB and allows to check PL/SQL code before sending to Oracle)

screen shots

Regards,
www.softema.com

 

[CTzen]

Excellent job! Thank you!

Reminds me the times when Oracle7 documentation came with tiny little SQL syntax book

 

[Marco Kalter]

Impressive stuff!

 

[Isaac Blank]

A quick try exposed a couple of problems that would render PL/SQL syntax checker unusable:

1. CREATE OR REPLACE PACKAGE BODY schema_owner.package_name

complains on encountering the dot

2. Does not inderstand analytic functions:
SELECT bo.billing_no, bo.bill_to_address_id,
dense_rank() over (ORDER BY bml_id DESC) rank

Complains that it expects comma or FROM after "over"

Still, I like it a lot - will recommend to fellow developers

 

[rbrooker]

it doesnt seem to work in all program windows. some i can get it to, but not others. its weird.

it also doesnt work for a command window editor.

otherwise its cool.

 

[softema.com]

Originally posted by Isaac Blank:
A quick try exposed a couple of problems that would render PL/SQL syntax checker unusable:

1. CREATE OR REPLACE PACKAGE BODY schema_owner.package_name

complains on encountering the dot

2. Does not inderstand analytic functions:
SELECT bo.billing_no, bo.bill_to_address_id,
dense_rank() over (ORDER BY bml_id DESC) rank

Complains that it expects comma or FROM after "over"

Still, I like it a lot - will recommend to fellow developers

Fixed. Thanks for your notice.

 

[Isaac Blank]

Originally posted by softema.com:

Originally posted by Isaac Blank:
A quick try exposed a couple of problems that would render PL/SQL syntax checker unusable:

1. CREATE OR REPLACE PACKAGE BODY schema_owner.package_name

complains on encountering the dot

2. Does not inderstand analytic functions:
SELECT bo.billing_no, bo.bill_to_address_id,
dense_rank() over (ORDER BY bml_id DESC) rank

Complains that it expects comma or FROM after "over"

Still, I like it a lot - will recommend to fellow developers

Fixed. Thanks for your notice.

The first issue has been fixed, thanks , but the second is still there

 

[softema.com]

Originally posted by Isaac Blank:
The first issue has been fixed, thanks , but the second is still there

What's your Oracle client version? 10g?

 

[Isaac Blank]

This is 9201 client. When I try it in 10g, it gives me "access violation" error

 

[Gevorg]

Hello,
It's a good product, thank you. I think it'll be better if you add features like Visual Assist for Visual Studio. For instance popup windows when you typing.

Best Regards,
Gevorg

 

[CTzen]

There is another problem with texType, please take a look at the screenshot. If Syntax Check is enabled, I cannot compile my trigger. If I turn it off, trigger compiles without any problem.

PL/SQL Developer 7.0.1.1066
Oracle Client 9.2.0
texType 2.0

 

[sukhadukkham]

hello,
i have the same problem, that it sometimes works and sometimes not.

it works in all sql-windows and NEW packages. in existing packages it sometimes works not ( but only in the package body ). it works in the package header.

any idea?

regards
daniel

 

[Kirurgs]

Well, this seems to be like a year old or smth...

So if someone dig this up, I'll add my 5 cents:
I encounter two major problems with texType:
1. I have set up (or this was the default one) shortcut to s = SELECT , so in comment like I would like to write -- this is comment line, what I get is, -- thiSELECT iSELECT etc., that is annoying...
2. when you reconnect (I'm not quite sure about this) or have new window, and try to use those shortcuts, they just doesn't work for first time, you have to delete that and start over, then it works... And sometimes it doesn't work at all, just doesn't, but I couldn't track what affects this...

PLSQLDev 7.0.3...

But it's impressive, I agree with Marco.

regards
Kirurgs