 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Larkov
Joined: 06 Oct 2008 Posts: 26 Country: Germany |
|
4.0 beta Indicator bar |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
Larkov
Joined: 06 Oct 2008 Posts: 26 Country: Germany |
|
It was not easy... :-) |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|