If there are virtual columns in the IG report, when we press button 'save' for adding, updating, deleting row. we often encounter an error:
'ORA-01733:virtual column not allowed here '
There are 2 solutions:
1) set the virtual columns 'dept name' 'location' as ' query only'
2)In the process, write PL/SQL:
begin
case
when :APEX$ROW_STATUS ='C' then
insert into emp(ename, job,mgr,hiredate,sal,comm,deptno)
values (:ename, :job,:mgr,:hiredate,:sal,:comm,:deptno)
return empno into :empno;
when :APEX$ROW_STATUS ='U' then
update emp set
ename=:ename,
job=:job,
mgr=:mgr,
hiredate=:hiredate,
sal=:sal,
comm=:comm,
deptno=:deptno
where empno=:empno;
when :APEX$ROW_STATUS ='D' then
delete from emp where empno=:empno;
end case;
end;
Негізгі бет How to solve 'ORA-01733:virtual column not allowed here ' in interactive grid in Oracle APEX
Пікірлер: 7