Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc04.gnilink.net.POSTED!53ab2750!not-for-mail
From: "news.verizon.net" <vhebbar@verizon.net>
Newsgroups: comp.databases.oracle.server
References: <8c1ec68c.0305030010.525ac4af@posting.google.com>
Subject: Re: SQL Works but PL/SQL hangs
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <CWAta.13098$TR3.1543@nwrddc04.gnilink.net>
Date: Mon, 05 May 2003 21:44:02 GMT
NNTP-Posting-Host: 141.150.125.168
X-Complaints-To: abuse@verizon.net
X-Trace: nwrddc04.gnilink.net 1052171042 141.150.125.168 (Mon, 05 May 2003 17:44:02 EDT)
NNTP-Posting-Date: Mon, 05 May 2003 17:44:02 EDT
Xref: core-easynews comp.databases.oracle.server:185348
X-Received-Date: Mon, 05 May 2003 14:43:30 MST (news.easynews.com)

Did you type "/" at the end?
declare
      x varchar2(50);
begin
      select trans_no into x from XYZ@remotedb;
end;
/

Anurag

"Amir" <amirrazakhan@hotmail.com> wrote in message
news:8c1ec68c.0305030010.525ac4af@posting.google.com...
> When I issue a statement to fetch some data from the remote database
> on the SQL prompt it works fine, as given below
>
>             SQL> select trans_no from XYZ@remotedb;
>
> But when I embbed the same query in PL/SQL block it hangs and does not
> complete
>
>             declare
>                x varchar2(50);
>             begin
>                select trans_no into x from XYZ@remotedb;
>             end;
>
>
> What could be the reason?
>
> ~~Amir