ORA-29531

From: Che <steve_at_cheguevara.zzn.com>
Date: 9 Jul 2002 07:50:21 -0700
Message-ID: <68e08091.0207090650.3d7201a6_at_posting.google.com>


Hi there

This is probably an error on my part, but it has me baffled and I would appreciate any help........

My java code is simple......

public
class Client
{

  public static void callBroker(String cpr, String[] data)   {

        data[0] = ("Client started: ");
  }
}

I issue the command

loadjava -u system/manager_at_che:1521:sag -t -r -v Client.java

then login to sqlplus as system and enter create or replace procedure client (cpr varchar2, data out varchar2) as language java
name 'CLient.callBroker(java.lang.String[], java.lang.String[])'; /

then create two variables
cpr varchar2(9);
data varchar2(200);
exec client(:cpr :data);
and get the errors

ERROR at line 1:

ORA-29531: no method callBroker in class Client
ORA-06512: at "SYSTEM.CLIENT", line 0
ORA-06512: at line 1

Thanks in advance

Che Received on Tue Jul 09 2002 - 16:50:21 CEST

Original text of this message