Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When using with DBLink: ORA-01453: SET TRANSACTION must be first statement of transaction
schreurs_roel_at_hotmail.com wrote:
> --
> begin
> declare cursor test is
> select <field> from <table>@<dblink> where <field> = 4;
> begin
> set transaction read only;
> open test;
> close test;
> commit;
> end;
> end;
> --
Any progress on this? Since parsing PL/SQL that contains distributed queries creates a transaction, why not move your set transaction read only to the outside of the PL/SQL block, above your first begin?
You said CoreLab's software sends set transaction at the beginning of their transaction. That doesn't sound like sending it as the first line *inside* a PL/SQL block or stored procedure, which is what you're simulating.
Yong Huang Received on Sat May 14 2005 - 23:20:18 CDT