Let's first see a series of executions:
SQL> create or replace view v_bmw_pay_online_new as 2 select * 3 from taobao.bmw_pay_online_new@lnk_db215; SQL> create or replace procedure sp_v_test is 2 v_id number; 3 begin 4 select id into v_id from v_bmw_pay_online_new where id = 1; 5 end; 6 /
Procedure created
SQL> Create or Replace Synonym S_BMW_PAY_ONLINE_NEW 2 for taobao.bmw_pay_online_new@lnk_db215;
Synynym CREATED
SQL> Create or Replace Procedure SP_S_TEST IS 2 V_ID Number; 3 Begin 4 SELECT ID INTO V_ID from S_BMW_PAY_ONLINE_NEW Where ID = 1; 5 End; 6 /
Warning: Procedure Created with Compiration Error
SQL> show errorerrors for procedure taobao.sp_s_test:
Line / col Error -------- -------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------- 4/29 PL / SQL: ORA-00600: Internal error code, parameter: [17069], [0x57E77854], [], [], [], [], [], [] 4/4 pl / SQL: SQL Statement Ignored
It can be seen that in the same remote object, I can create a view, then create a stored procedure on that view, but if I make a synonym of the remote operation, then create a stored procedure on the synonym ORA-00600 is reported. Tracking is no fruit, what does not see what is generated, Metalink, search "ORA-00600 17069", found that there is a lot of things that appear, roughly the library cache error, but how can I generate this error? Online Contact A Oracle Online Technical Support, talked for a while, the problem is solved, but he is not admitted to be bug, huh, huh.
The following is a summary of chat: ORA-00600 [17069] REORTED ON COMPILING A Procedure.
Invalid Lock in Library Cache.unable to Pin The Object and Hence The Error.
Clearing The Shared Memory Will Help To Get Rid of Inconsistant Information In Memory Which IS Causeing The Error.
