Using PLSQl in Oracle reports [message #88089] |
Wed, 27 February 2002 03:18 |
Anderson
Messages: 10 Registered: December 1999
|
Junior Member |
|
|
I have writen a PLSQ Function in reports which complis but when I try to use it in my select statement I get the ERROs (Invalid Column) Can you please help. Is there a specific place where I have to store this function in reports?
|
|
|
Re: Using PLSQl in Oracle reports [message #88094 is a reply to message #88089] |
Wed, 27 February 2002 20:24 |
Sethunath
Messages: 15 Registered: February 2002
|
Junior Member |
|
|
Kadzombe,
Specify the full decription of error message. I think either you didn't give the absolute column name. Like USER.TANLE.COLUMN_NAME. or The Field refers to invalid column.
|
|
|
Re: Using PLSQl in Oracle reports [message #88101 is a reply to message #88094] |
Mon, 11 March 2002 10:21 |
selma
Messages: 3 Registered: March 2002
|
Junior Member |
|
|
Try to send return value into one variable and then your function should return this variable instead of hardcoded string, as follows:
FUNCTION EnrolmentStatus (SCE_STAC in varchar2) RETURN varchar IS
Status VARCHAR(2);
Return_Status VARCHAR2(1);
BEGIN
Status := :SCE_STAC;
if Status like '0%'
then
Return_Status := 'y';
else
Return_Status := 'n';
end if;
return(Return_Status);
END;
|
|
|