SQL Works but PL/SQL hangs

From: Amir <amirrazakhan_at_hotmail.com>
Date: 3 May 2003 01:10:49 -0700
Message-ID: <8c1ec68c.0305030010.525ac4af_at_posting.google.com>

[Quoted] [Quoted] When I issue a statement to fetch some data from the remote database [Quoted] [Quoted] on the SQL prompt it works fine, as given below

[Quoted]             SQL> select trans_no from XYZ_at_remotedb;

[Quoted] [Quoted] But when I embbed the same query in PL/SQL block it hangs and does not complete

[Quoted]             declare
[Quoted]                x varchar2(50);
            begin
[Quoted] [Quoted]                select trans_no into x from XYZ_at_remotedb;
            end;

What could be the reason?

~~Amir Received on Sat May 03 2003 - 10:10:49 CEST