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: 7951
|
|
|
|
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: 7951
|
|
|
|
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 |
|
 |
|