Re: SQL Works but PL/SQL hangs

Did you type "/" at the end?
declare

      x varchar2(50);
begin

      select trans_no into x from XYZ_at_remotedb; end;
/

Anurag

"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
Received on Mon May 05 2003 - 16:44:02 CDT