[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Plsql mode indenting broken on windows
From: |
kcrews02460 |
Subject: |
Re: Plsql mode indenting broken on windows |
Date: |
26 Oct 2006 06:50:09 -0700 |
User-agent: |
G2/1.0 |
In my previous post I failed to get the start of the 2nd error message.
It begins:
Search failed: "[
()]\\(a\\(?:ccess\\|dd\\|l\\(?:l\\|ter\\)\\
kcrews02...@gmail.com wrote:
> I'm running gnu emacs 21.3.1 on windows xp. I downloaded plsql.el
> (version Version: 0.8.0) yesterday and it does not work properly.
> Specifically, if I try to indent code I one of 2 errors:
>
> Invalid search bound (wrong side of point)
>
> or
>
> \\|dd\\|l\\(?:l\\|ter\\)\\|n\\(?:alyse\\|[dy]\\)\\|sc?\\|
> udit\\|vg\\)\\|b\\(?:etween\\|y\\)\\|c\\(?:heck\\|luster\\|o\\(?:lumn\\|
> m\\(?:m\\(?:\\(?:en\\|i\\)t\\)\\|press\\)\\|n\\(?:nect\\|tinue\\)\\)\\|
> reate\\|urrent\\)\\|d\\(?:e\\(?:clare\\|lete\\|sc\\)\\|istinct\\|
> rop\\)\\|e\\(?:scape\\|x\\(?:ec\\|ists\\|plain\\)\\)\\|f\\(?:loat\\|
> o\\(?:r\\(?:\\(?:eig\\|tra\\)n\\)\\|und\\)\\|rom\\)\\|g\\(?:o\\|r\\(?:ant\\|
> oup\\)\\)\\|having\\|i\\(?:dentified\\|mmediate\\|n\\(?:crement\\|dex\\|itial\\|sert\\|
> t\\(?:eger\\|o\\)\\)?\\)\\|key\\|l\\(?:evel\\|ike\\|o\\(?:ck\\|ng\\)\\)\\|
> m\\(?:ax\\|in\\(?:us\\)?\\|od\\(?:e\\|ify\\|ule\\)\\)\\|
> n\\(?:o\\(?:\\(?:\\(?:aud\\|wa\\)i\\)?t\\)\\|u\\(?:ll\\|
> meric\\)\\)\\|o\\(?:ffline\\|nline\\|ption\\|rder\\|[fnr]\\)\\|
> p\\(?:ctfree\\|li\\|ri\\(?:mary\\|or\\)\\|ublic\\)\\|
> r\\(?:e\\(?:\\(?:nam\\|sourc\\|vok\\(?:\\)?\\)e\\)\\|o\\(?:llback\\|
> w\\(?:id\\|num\\|s\\)?\\)\\)\\|s\\(?:chema\\|e\\(?:ction\\|lect\\|ssion\\|
> t\\)\\|hare\\|ize\\|ome\\|ql\\(?:code\\|error\\)\\|tart\\|y\\(?:nonym\\|
> sdate\\)\\)\\|t\\(?:able\\|o\\|r\\(?:igger\\|uncate\\)\\)\\|u\\(?:id\\|
> ni\\(?:on\\|que\\)\\|pdate\\|ser\\)\\|v\\(?:al\\(?:idate\\|ues\\)\\|iew\\)\\|
> w\\(?:he\\(?:never\\|re\\)\\|ith\\|ork\\)\\)[
>
> ()]" Quit
>
> (Note - the 2nd error is really one long line - I added newlines for
> readibility. Also, it looks kind of odd because the first characters
> of the keywords are missing "etween" instead of "between", "able"
> instead of "table", etc.)
>
> The version of sql.el that comes with this version of emacs is Version:
> 1.6.3. I tried downloading the most recent version of sql.el (2.0.1
> from
> http://cvs.savannah.gnu.org/viewcvs/*checkout*/emacs/emacs/lisp/progmodes/sql.el)
> but that did not help. (plsql mode depends on sql.el) Apparently it
> was tested with emacs 22.1 and might not work with earlier versions of
> emacs. I have not found any more recent version of emacs for windows
> than the one I am running, even though it was built in 2004.
>
> Does anyone know of either
>
> 1) a fix for the indenting problems
>
> 2) versions of gnu emacs, sql.el and plsql.el that work together on
> windows?
>
> The code below shows the problem. If you select the entire buffer and
> indent it (C-\), you get the Invalid search bound error. If you put
> the cursor at the beginning of the line starting FUNCTION, and press
> tab, you get the other error.
>
> CREATE OR REPLACE PACKAGE BODY Indent_prob AS
>
> FUNCTION get_da_value(i_attr_name IN
> gt_product_profile.attribute%TYPE,
> i_def_value IN gt_product_profile.char_value%TYPE
> DEFAULT NULL)
> RETURN VARCHAR2
> AS
> v_value gt_product_profile.char_value%TYPE := i_def_value;
> BEGIN
> SELECT char_value
> INTO v_value
> FROM gt_product_profile pp
> WHERE ATTRIBUTE = i_attr_name
> and UPPER(pp.userid) = 'PUBLIC';
>
> RETURN v_value;
> EXCEPTION WHEN NO_DATA_FOUND THEN
> IF v_value IS NULL THEN
> RAISE;
> END IF;
> RETURN v_value;
> END;
> END Sce_Notification_Util;
> /