Home » Developer & Programmer » JDeveloper, Java & XML » ORA-29531: no method getarea in class testFunction
ORA-29531: no method getarea in class testFunction [message #91986] Tue, 13 January 2004 22:15 Go to next message
Jeffrey
Messages: 30
Registered: January 2003
Member
Why do i get these messages? The method getarea is very well in the testFunction class. I have also put in the modifier as public static. I have tested this method in JBuilder and it works ok, but how come it is not found after i load it into oracle. Can someone help me here?

Report message to a moderator

Re: ORA-29531: no method getarea in class testFunction [message #92417 is a reply to message #91986] Tue, 06 July 2004 06:55 Go to previous message
Francis Fish
Messages: 1
Registered: July 2004
Junior Member
Hi

when you create the function in PL/SQL all of the object types must be fully qualified e.g.:

CREATE OR REPLACE function test1 ( String in varchar2 ) return varchar2
AS LANGUAGE JAVA
NAME 'Test.test1(java.lang.String) return java.lang.String';
/

I got this from another place on the Web.
http://archive.devx.com/dbzone/articles/sqlj/sqlj03/sqlj040202-5.asp, see the author's note about half way down.

Hope this helps.

Report message to a moderator

Previous Topic: data_type for blob field
Next Topic: xml help PLEASE!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:29:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.