ORA-00942: table or view does not exist - It DOES exist - 19c
Hello,
We have upgraded the Oracle database from 12c to 19c on Oracle EBS 12.2.8 environment. For some of our programs, we get ORA-00942 error (mentioned above).
- BELOW IS THE PLSQL CODE
In PLSQL code:
PROCEDURE (errbuf out varchar2, retcode out varchar2) IS
avar varchar2(40) := 'My Name Is';
bvar varchar2(40) := 'JOHNSMITH';
begin
select intro, name into avar, bvar from mytable where rownum = 1;
dbms_output.put_line('code starts here');
dbms_output.put_line('details:'||avar||bvar);
end;
- WHEN I RUN THIS CODE FROM SQL PLUS
It is a success. No issues, output print just fine.
- WHEN I RUN THIS CODE FROM EBS, AS CONCURRENT PROGRAM, I GET FOLLOWING AND THE REQUEST ENDS UP IN RED.
0