else if body is not correct.

Please tell me what is wrong in the below query:
(Very Urgent)
=================================================
function BeforePForm return boolean is
begin
if :from_invoice_date is null OR :to_invoice_date is
null then
aiv.PERIOD_NMAE:=:gl_period
elsif :gl_period is null then
aiv.INVOICE_DATE between :from_invoice_date
and :to_invoice_date
end if;

return (TRUE);
end;

Question Posted / hari

2 Answers
6275 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / hari

else if body is not correct.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2278

from where do u receive the information to develop report

2048

How can we generate report output in excel format?

1036

what is oracle forms?

1158

What is the difference between bind and lexical parameter?

1114

Why oracle forms required?

1093

how report can be generated if we have the database designed in oracle 10g?

1934

where do u put the report file

2133

did u received a single file or multiple files

2057

Explain how one can iterate through items and records in a specified block?

1215

In what situation u create the BPA.

2248

i am writing a query select EmpNo from Emp how can i call in after parameter form

2185

What is responsibility and how u attach How to create user and how u attach with responsibility.

2091

What is the difference between flex mode and confined mode?

1104

What is a user exit program in oracle reports?

1078