Error while calling java stored procedure in oracle database

[Sagar Deshmukh]

i have created a RunnableJar(Jar contain another third party jar like iText ,java class, etc etc ) and i have upload that RunnableJar.jar in oracle database using loadjava
in that jar i have main class GetOffer in that i have one

public String getOffer(String param1) { }

method and the use of this method is to create multiple pdf according to user selection and concat them.
Now i have created Stored procedure

create or replace function getOffer(param1 in varchar2) return varchar2
                       is language java name 'GetOffer.getOffer(java.lang.String) return java.lang.String';
                       / 

and i have called this stored procedure using following call statement

SQL> VARIABLE  myString  VARCHAR2(20);
                               SQL> CALL getOffer("XYZ") INTO :myString

while Calling the procedure we are getting the below error.

SQL> VARIABLE myString VARCHAR2(20);
SQL> CALL getOffer("XYZ") INTO :myString
2 ;
CALL getOffer("Any String") INTO :myString
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name

Guys how to solve this problem.

[Martin Vashko]

Let's continue the discussion in the thread you've created in the right forum: https://coderanch.com/t/613768/Oracle-OAS/runnable-jar

Locking this thread.