Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-29531 Error - and the method is declared both PUBLIC and STATIC
Could someone be of assistance and show me the problem with the
following code? I have researched Metalink regarding ORA-29531, and the
most common cause of this error is the failure to declare the method
"public" and "static". I have done both here and still have the same
error:
Java Code::::::::::::::::::::::::::::::::::::::::::::::
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "TimeZoneFormatter" AS
import java.util.TimeZone; import java.util.Date; import java.text.DateFormat;
public class TimeZoneFormatter {
public static String Convert(String clientTimezone, Date clientDate)
{
//set the format for the dates
DateFormat dateFormatter =
DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG);
TimeZone timeZoneClient = TimeZone.getTimeZone(clientTimezone);
// Set the time zone of the date formatter to Client time
zone.dateFormatter.setTimeZone(timeZoneClient);
return dateFormatter.format(clientDate);
}
}
;
/
Wrapper Code:::::::::::::::::::::::::::::::::::::::::::::::;
CREATE OR REPLACE function TimeZoneFormatter (ClientTimezone varchar2,
ClientDate varchar2)
return varchar2 as
language java
name 'TimeZoneFormatter.Convert(java.lang.String, java.lang.String)
return java.lang.String';
/
Test:::::::::::::::::::::::::::::::::::::::::::::::::;
select TimeZoneFormatter('Europe/Paris','Wed Mar 09 23:22:24 CST
2005') from dual ;
*
ERROR at line 1:
ORA-29531: no method Convert in class TimeZoneFormatter
Thank you very much in advance!
Jeff Received on Fri Mar 11 2005 - 14:19:01 CST
![]() |
![]() |