While testing the procedure i am receiving the following error during
bulk insertion:-
begin
insert into table_name select * from view;
exception
print(' ');
end;
-2068:ORA-02068: following severe error from PHOENIX
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.224.124.9)
(PORT=1531)))(CONNECT_DATA=(SID=tg4sybs7)))
The procedure runs fine for one record but fails under bulk insertion.
I googled, but all my effort was in vain.
Can anyone tell me how to resolve the above error.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
