can not insert through dblink in procedure
I have created one procedure which is selecting,inserting and updating data to another database on same server using dblink. it select and update data successfully but when it is going to insert using dblink it gives following error.
ORA-02019: connection description FOR remote DATABASE NOT FOUND
ORA-02063: preceding line FROM PAS
But when i executed same insert statement on sql prompt it is exeuted successfully.
insert into tab1@dblink values('blah','blah','blah');
I have dropped all my dblink and recreate it again i have given priveleges externally means insert any table,select any table,update any table to username.
but still i have recieved same error. Please guide me.
Thanks in advance