Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implement Java Class into Report Builder

419095May 16 2004 — edited May 17 2004
Hi, I have problems implementing own java classes into the Report Builder. OK, let say I am running a simple report using STUDENT_ID and STUDENT_NAME. What I wanted to do is to concatenate a string "XXXX" to one of the records in STUDENT_NAME (e.g. STUDENT_NAME = 'Mary').

The Java class that I wrote has a static method:
public class MyAppend
{
public static String myMethod(String s)
{
s = s +"XXXX";
return s;
}
}

I also wrote a Formula Column in Report Builder called "TestFormula":
function TestFormula return varChar2 is
StuName varchar2(40);
myStr varchar2(40);
begin
select STUMST.STU_NAME
into StuName
from STUMST
where STUMST.STU_NAME= 'Mary';
->myStr := myappend.myMethod(myPackage.aobj, StuName);
return myStr;
end;

The error message I get when I compile this Formula Column PL/SQL is (with '->' pointing to the line):
Wrong number or types of arguments in call to 'MYMETHOD'

How do I correct this error?

Thank you.

Joey


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2004
Added on May 16 2004
3 comments
333 views