Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Works but PL/SQL hangs
(NOTE followup set to just comp.databases.oracle.misc)
Amir wrote:
> 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
Is the query really that simple? Is the XYZ table actually maybe a view? Are you joining tables?
I have had remote transactions that seemed to hang, but were really just slow performance over the link. For example, trying to join a local table with a remote one can give LONG (tens of hours) exection times.
-- Ed Prochak running http://www.faqs.org/faqs/running-faq/ netiquette http://www.psg.com/emily.html -- "Two roads diverged in a wood and I I took the one less travelled by and that has made all the difference." robert frostReceived on Mon May 05 2003 - 08:12:21 CDT