Re: SQL Works but PL/SQL hangs

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 7 May 2003 19:35:36 +0100
Message-ID: <3eb9521f_3@mk-nntp-1.news.uk.worldonline.com>

"Amir" <amirrazakhan_at_hotmail.com> wrote in message news:8c1ec68c.0305030010.525ac4af_at_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_at_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_at_remotedb;
> end;
>
>
> What could be the reason?
>
> ~~Amir

If *exactly* as described, you now have the anonymous block (chunk of PL/SQL code) in the /SQL*Plus buffer. SQL*Plus is now waiting for you. To execute the block, type a forward slash on the next line, then press Enter.

Regards,
Paul Received on Wed May 07 2003 - 13:35:36 CDT