Help with PL/SQL [message #39340] |
Tue, 09 July 2002 05:09 |
Hadi Sulistio
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
I am getting this error message in my code:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: * & = - + ; < / > at in mod not rem <an exponent (**)> <> or != or ~= >= <= <> and or like between is null is not || is dangling
Here is my code:
DECLARE
n_updper int := [[UPDPER]];
n_month int;
s_updper varchar2(20);
BEGIN
s_month := to_char(bitand(n_updper, 253952) / 8192);
s_updper := to_char(1900 + bitand(n_updper, 536608768) / 262144) || '.12';
DELETE FROM [[WORKTABLE]] z
WHERE flow IN (SELECT flow
FROM Tperload
WHERE rtrim(mth_num) >= s_month)
AND nature = 3 /*ACT*/
AND period = (to_number(substr(s_updper(s_updper, 1, 4))) - 1900) * 262144) + (to_number(substr(s_updper, 6, 7)) * 8192);
END;
Can anybody help?
Thanks in advance:)
Hadi
|
|
|
|