Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FROM keyword not found where expected

Engineerr1983Jan 8 2024 — edited Jan 8 2024

Hi,

Below is SQL statement used in server side condition (PL SQL function body) to get a LOB column length,

declare
begin
IF :Lctr_id is not null then

for c1 in (select nvl(dbms_lob.getlength(LECTURER_TBL.LECTURE_VIDEO),0) 1
FROM LECTURER_TBL
where LECTURER_TBL.LCTR_ID=:Lctr_id)
loop
if c1.1 > 0 then
return true;
end if;
end loop;
end if;
return false;
end;

But it gave an error as show below in attachments, one of them during runtime and other during SQL statement validation.

but in runtime there are 2 errors not just one.

the main table is (LECTURER_TBL)

and it's columns shown in the 3rd attachment

Comments
Post Details
Added on Jan 8 2024
5 comments
201 views