incorrect query result using remote read-only database

@remotedb

hi all

i need some help in solving strage behaviour of select statement based on local and remote database

note

- dblink @remotedb looks to read-only database (standby)

- if dblink looks to other database which is in read-write mode, then such problem i don't see

may be problem in read-only mode of database ?

BANNER                                                                               CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0PL/SQL Release 12.1.0.2.0 - Production                                                    0CORE 12.1.0.2.0 Production                                                                  0TNS for Linux: Version 12.1.0.2.0 - Production                                            0NLSRTL Version 12.1.0.2.0 - Production                                                    0 (for all databases)/*create table table_of_ids(id  varchar2(15))/insert into table_of_ids values('ID-1');commit;create table table_needs1(id  varchar2(15))/*/declareprocedure