"Not Supported"-- Error message

[manush]

Hi,

I wrote a pl/sql package and used it in crystal report to get the data.

Then I made some changes (some more criteria using If..Else )in the pl/sql package and compiled it again. It compiled well without giving any error.

Then I tried to use it in the same report as well as I created a new report. But in all cases it is giving an error message --- "Not Supported"...

Please suggest a solution.

Cheers,
Manoj

 

[hneal98]

Don't think you can use the If..Else in there.

 

[manush]

Hi,

We can use If..Else... my package is written with Pl/SQL and we can you Pl/SQL as below.

procedure test(a in number)
IS
Begin

If a>10 Then
a:=a-10;
else
a:=a+10;
end if;

dbms_output.put_line(a);
End;

cheers,
Manoj

 

[hneal98]

My apologies. Mis-understood.