[ jEdit-devel ] [ jedit-Plugin Bugs-1046095 ] SQL Plugin conflict with jEdit Explicit Fold

[SourceForge.net <no...@so...>]

Plugin Bugs item #1046095, was opened at 2004-10-13 10:18
Message generated for change (Comment added) made by mamartin7
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=565475&aid=1046095&group_id=588

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Open
Resolution: Out of Date
Priority: 5
Private: No
Submitted By: Mark Martin (mamartin7)
Assigned to: Sergey V. Udaltsov (svu)
Summary: SQL Plugin conflict with jEdit Explicit Fold

Initial Comment:
Not so much a bug, as a workaround required.

I put some explicit folds in my stored procs code and 
now I cannot submit them to my Oracle database.

My folds are like this:

--{{{ A comment
... Oracle code
--}}}

I get a java.sql.SQLException: Non supported SQL92 
token at position nn: when I try to execute the buffer.

It seems that Oracle JDBC drivers support some 
embedded SQL92 syntax which is delimited by { and }.

Could we have some functionality to optionally switch 
off escape processing for SQL92 syntax, or should I be 
approaching this another way.

Thanks

MM




----------------------------------------------------------------------

>Comment By: Mark Martin (mamartin7)
Date: 2007-04-05 11:23

Message:
Logged In: YES 
user_id=910899
Originator: YES

I reopened the call as it is still not working for me, but I have new
information. I am using SQL Plugin 1.06 against Oracle 10g database and the
latest ojdbc14.jar I could find.

If I try to submit this procedure

CREATE OR REPLACE PROCEDURE foldtest
--{{{ Fold comment
--}}}
  l_null VARCHAR2(10);
BEGIN
  SELECT NULL INTO l_null FROM DUAL;
END;

I get a java.sql.SQLException: Non supported SQL92 token at position 40.

If I add a single quote before the first {

CREATE OR REPLACE PROCEDURE foldtest
--'{{{ Fold comment
--}}}
  l_null VARCHAR2(10);
BEGIN
  SELECT NULL INTO l_null FROM DUAL;
END;

then this procedure can be submitted.

If I add another single quote before the first }

CREATE OR REPLACE FUNCTION foldtest
--'{{{ Fold comment
--'}}}
  l_null VARCHAR2(10);
BEGIN
  SELECT NULL INTO l_null FROM DUAL;
END;

then I get a java.sql.SQLException: Malformed SQL92 string at position
60.

It seems that it will only accept explicit folds if they are inside a
single quote string.

----------------------------------------------------------------------

Comment By: Sergey V. Udaltsov (svu)
Date: 2007-03-16 17:30

Message:
Logged In: YES 
user_id=681
Originator: NO

I think it just matter of incorrect statement delimiter in the oracle
database type. Since it was changed since that time - it should be ok now.
I am closing this one. If it is still the issue - feel free to reopen.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=565475&aid=1046095&group_id=588