From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: kcrews02460@gmail.com Newsgroups: gmane.emacs.help Subject: Plsql mode indenting broken on windows Date: 26 Oct 2006 06:44:26 -0700 Organization: http://groups.google.com Message-ID: <1161870266.747841.76400@b28g2000cwb.googlegroups.com> NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: sea.gmane.org 1161873678 29326 80.91.229.2 (26 Oct 2006 14:41:18 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 26 Oct 2006 14:41:18 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Oct 26 16:41:15 2006 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by ciao.gmane.org with esmtp (Exim 4.43) id 1Gd6PH-0004wO-QM for geh-help-gnu-emacs@m.gmane.org; Thu, 26 Oct 2006 16:40:34 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Gd6PH-00044z-C4 for geh-help-gnu-emacs@m.gmane.org; Thu, 26 Oct 2006 10:40:31 -0400 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!postnews.google.com!b28g2000cwb.googlegroups.com!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 80 Original-NNTP-Posting-Host: 199.232.43.35 Original-X-Trace: posting.google.com 1161870272 30205 127.0.0.1 (26 Oct 2006 13:44:32 GMT) Original-X-Complaints-To: groups-abuse@google.com Original-NNTP-Posting-Date: Thu, 26 Oct 2006 13:44:32 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: b28g2000cwb.googlegroups.com; posting-host=199.232.43.35; posting-account=ndYATw0AAACiktJrsc4Pzuz-nstcJlW3 Original-Xref: shelby.stanford.edu gnu.emacs.help:142675 Original-To: help-gnu-emacs@gnu.org X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:38296 Archived-At: 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; /