Home » SQL & PL/SQL » SQL & PL/SQL » Help with PL/SQL
Help with PL/SQL [message #39340] Tue, 09 July 2002 05:09 Go to next message
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
Re: Help with PL/SQL [message #39341 is a reply to message #39340] Tue, 09 July 2002 05:30 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
syntax error in this line .. check it

AND period = (to_number(substr(s_updper(s_updper, 1, 4))) - 1900) * 262144) + (to_number(substr(s_updper, 6, 7)) * 8192);
Previous Topic: SQL to Concat colmn values of Diff records
Next Topic: lock record
Goto Forum:
  


Current Time: Fri Mar 29 10:07:40 CDT 2024