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
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
and i have called this stored procedure using following call statement
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.