mulander/oracle.tmbundle

Oracle PL/SQL TextMate bundle for Sublime Text 2/3.

oracle.tmbundle's Issues

Please add a license to this repository

Hello there, we'd love to use this grammar in https://github.com/github/linguist (github-linguist/linguist#2082) but before we can include it we need you to add a license to the repository. MIT/Apache-2 is preferred but you can read more about possible options here: http://choosealicense.com/

Thanks in advance!

Type Capture not Highlighting Entity Name

The capture for highlighting Types doesn't work correctly. The regex, (?i)\b(type)\s+"([^"]+)", isn't matching TYPE definitions. (But TYPE is also a Keyword, so the word TYPE is still being highlighted.)

Example 1 - Type Definition in a Package:

TYPE tzrakhd_ref IS REF CURSOR RETURN tzrakhd_rec;

The word TYPE is highlighted, matching the keyword, but tzrakhd_ref is not highlighted as the entity name.

Example 2 - User Defined Type:

CREATE OR REPLACE TYPE schema.testtype

Again the word TYPE is highlighted, but schema.testtype isn't.

I have tried a few regex variations to get the correct match, but haven't found one that works.

(?i)\b(type)\s+(\S+)

This one correctly matches both examples above, but incorrectly highlights the following example.

Example 3 - Function or Procedure Parameter definition:

p_hold_id tzrakhd.tzrakhd_hold_id%TYPE DEFAULT NULL,

The word TYPE is correctly highlighted, but the word DEFAULT gets highlighted as an entity name instead of as a keyword.

(?i)\s+\b(type)\s+(\S+)

This one correctly highlights Example 1 and 3, but doesn't highlight Example 2 correctly.

I am willing to test any Regex suggestions that might correctly match. If we could get the Type capture to match correctly, I would recommend changing the TYPE and ROWTYPE keywords to %TYPE and %ROWTYPE to be consistent with %ISOPEN, %FOUND, %NOTFOUND, and %ROWCOUNT attributes.

There is no instruction on how to use your package

Hi, I'm new to sublime text 3 but I can already see how awesome it is, but to write plsql code, your plugins is really helpfull but I have no idea how to setup the connection and make the file execute. Could you help me a little ?

Your help is really appreciated

Would you consider re-licensing this repository?

Hello there, we'd love to use this library to syntax-highlight files on GitHub but in order to do so we need this library to have a more permissive license.

If you don't have any particular reason for choosing GPL would you be willing to consider switching this to a more permissive license such as MIT, BSD or Apache 2?

Many thanks
Arfon (GitHub Staff)

Case preference for snippets

Would it be possible to add a preference to control the case of snippets at time of insert? For example, with my coding style I'd like them to all be lower case.