| Validation Subquery [message #89731] |
Mon, 12 July 2004 07:51  |
Steve
Messages: 190
Registered: September 1999
|
Senior Member |
|
|
Hi all -
I am running Reports 6i and I would like to know if its possible to write a subquery in a validation function? I have a parameter that I want to validate against a column in the DB (using literals will require too much upkeep) but I get a message saying a subquery can't be used in this context when I put the PL/SQL in the validate trigger. Here is my code:
function P_UNIONValidTrigger return boolean is
begin
if :p_union IN
(select segment1 from pay_people_groups) THEN
return (TRUE);
else
return (FALSE);
end if;
end;
Pretty simple, but subquery not allowed? If not, how can I accomplish this? Thanks in advance!
Regards,
Steve
|
|
|
|
| Re: Validation Subquery [message #89743 is a reply to message #89731] |
Wed, 14 July 2004 23:35  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Why don't you chnage it as follows:
function P_UNIONValidTrigger return boolean is
L_num Number(10):=0;
begin
Begin
select count(1) into from pay_people_groups
where segment1 =:p_union;
exception
when other then L_num:=0;
end;
if L_num>0 Then
return (TRUE);
else
return (FALSE);
end if;
end;
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
