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


