Re: PL/SQL: stored function called from SQL hangs... sometimes

From: H. John C. Hopkins <john_nospam_at_hpe.ufl.edu>
Date: 1998/03/16
Message-ID: <6ejbtr$nl4@no-names.nerdc.ufl.edu>#1/1

Andrew,

Thanks for the tips. As for #1, you're right.

#2: I tried limiting the rows returned... still no luck.

Still troubleshooting, though. Thanks for the tips.

-John

Andrew Barnett wrote in message
<01bd4bb0$236e4b40$8c0564a1_at_azmelw1358.mel.az.bp.com>...
>1. I would guess that you have some package-level constants, variables or
>code which get initialised the first time you call the package in a session
>and the value_error exception is raised. Subsequent calls don't run that
>code again, so no more errors.
>
>2. how many rows in customers table? maybe Oracle has not locked, just is
>taking very long time to apply the function to each row. pl/sql is not
>fast. try adding "where rownum = 1" or some other restriction to the query
>to reduce the number of rows, just to verify that the thing works.
>
>--
>Andrew - Wizzard
>
>barnetaj_at_bp.com
>
>
Received on Mon Mar 16 1998 - 00:00:00 CST