Re: SQL in FORMS4.5 Problem

The BEFORE way will not work if there aren't any rows in the pi_administrator table. If there is atleast one row it should always work. I'm not sure why you're doing a SELECT INTO to get the user when "USER" can be assigned directly in PL/SQL: usr := user;

Steve J.

Peter D. Hay wrote:
>
> Here is an odd Oracle SQL situation. Notice we eliminated the sub-select
> because 'user' can be found in ANY Oracle Object. The BEFORE situation
> works for some Users but not all. The AFTER works for all Users. Why
> ?? One theory: The 'IN' is causing something weird to happen.
>
> BEFORE:
>
> SELECT lower(user)
> INTO user_hold
> FROM dual
> WHERE lower(user) IN
> (SELECT lower(user_id) from pi_administrator);
>
>
>
>
> AFTER:
>
> SELECT user_id
> INTO user_hold
> FROM pi_administrator
> WHERE lower(user) = lower(user_id);
>
> Ideas ?
>
> --
> Peter Douglas Hay, Project Manager, Boeing, PI Systems,
> VOICE:(425) 865-4948 FAX:(425) 865-3555 HOME:(425) 641-6050
> INTERNET: peter.d.hay_at_usa.net Building:33-05 Mail Stop:7J80
Received on Mon Jun 02 1997 - 00:00:00 CEST