Home » Developer & Programmer » Reports & Discoverer » Using PLSQl in Oracle reports
Using PLSQl in Oracle reports [message #88089] Wed, 27 February 2002 03:18 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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;
Previous Topic: Reports6i
Next Topic: rwrbe60.exe problems on windows2000
Goto Forum:
  


Current Time: Sat May 18 12:39:34 CDT 2024