SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
4.0 beta Indicator bar

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
4.0 beta Indicator bar
Author Message
Larkov



Joined: 06 Oct 2008
Posts: 26
Country: Germany

Post 4.0 beta Indicator bar Reply with quote
In procedures the "Indicator bar" shows false syntax where no false syntax is.

It says f.e. that a variable, which is correctly declared, is an "invalid identifier".

Update 1: I found the problem. Up to the moment the code is compiled it shows many syntax errors which disappear after compile...

Update 2: in a procedure

create or replace procedure PRUEF_KRED(iSeqNr in number) is
vTyp varchar2(50);
BEGIN
{some commands};

END;

it says about the last line (END;): PLS-0103 encountered the symbol end-of-file when expecting one of the following...

Even AFTER compiling...

Larkov


Last edited by Larkov on Thu Oct 09, 2008 9:42 am; edited 1 time in total
Thu Oct 09, 2008 9:11 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
Could you please provide an example script demonstrating this issue or maybe a screenshot with the valid script and incorrectly marked syntax errors?
Thu Oct 09, 2008 9:41 am View user's profile Send private message
Larkov



Joined: 06 Oct 2008
Posts: 26
Country: Germany

Post It was not easy... :-) Reply with quote
Please do not execute the procedure. It is just for showing the problem. The problem disappears, if I delete the declaration
"vTyp varchar2(50);" (and of course the line "vTyp:=iSeqNr;").

---snip---

create or replace procedure AAAAA(iSeqNr in number) is
vTyp varchar2(50);
BEGIN
INSERT INTO dual(dummy)
SELECT (CASE WHEN 1=1 THEN 2 ELSE 1 END)
FROM dual;

vTyp:=iSeqNr;

END;

---snap---
Thu Oct 09, 2008 9:57 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
I'm not getting "PLS-0103 encountered the symbol end-of-file when expecting one of the following..." but getting "ORA-06550 encountered the symbol end-of-file when expecting one of the following...

And this seems to occur when INSERT..SELECT contains CASE within SELECT list. If I remove CASE, no syntax error is reported. I'm not sure about the root cause, but something obviously is not right here. I will submit this issue to development team for further investigation.
Thu Oct 09, 2008 10:18 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.