Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-29531 Error - and the method is declared both PUBLIC and STATIC

ORA-29531 Error - and the method is declared both PUBLIC and STATIC

From: jfk2001 <jkstexas2001_at_yahoo.com>
Date: 11 Mar 2005 12:19:01 -0800
Message-ID: <1110572341.836911.321230@z14g2000cwz.googlegroups.com>


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(clientTim­­ezone); // Set the time zone of the date formatter to Client time zone.dateFormatter.setTimeZone(time­­ZoneClient);

return dateFormatter.format(clientDat­­e);

}
}

;
/

Wrapper Code::::::::::::::::::::::::::­­:::::::::::::::::::::;


CREATE OR REPLACE function TimeZoneFormatter (ClientTimezone varchar2, ClientDate varchar2)
return varchar2 as
language java
name 'TimeZoneFormatter.Convert(jav­­a.lang.String, java.lang.String)

return java.lang.String';
/

Test::::::::::::::::::::::::::­­:::::::::::::::::::::::;


select TimeZoneFormatter('Europe/Pari­­s','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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US