Re: Java Procedure Doesn't Exist When Executed

From: Michael O'Shea <michael.oshea_at_tessella.com>
Date: 12 Jun 2006 06:30:10 -0700
Message-ID: <1150119010.760445.166500@g10g2000cwb.googlegroups.com>

> Resant wrote:
>
>
> when I execute it from Oracle, it shows error :
>
> class EXECCOMMAND does not exist
>

In your code, Java class "EXECCOMMAND" does not exist. In your code, Java class "ExecCommand" does.

Revise your code to:

CREATE OR REPLACE FUNCTION EXEC_COMMAND(Command IN varchar2) RETURN NUMBER AS
LANGUAGE JAVA
NAME 'ExecCommand.runCommand(java.lang.String) return int'; /

Regards
Mike

TESSELLA Michael.OShea_at_tessella.com

__/__/__/  Tessella Support Services plc
__/__/__/  3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/  Tel: (44)(0)1235-555511  Fax: (44)(0)1235-553301

www.tessella.com Registered in England No. 1466429 Received on Mon Jun 12 2006 - 08:30:10 CDT