Bookmark Topic Watch Topic
  • New Topic

Error while calling java stored procedure in oracle database  RSS feed

 
Sagar Deshmukh
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Report post to moderator
Let's continue the discussion in the thread you've created in the right forum: http://www.coderanch.com/t/613768/Oracle-OAS/runnable-jar

Locking this thread.
 
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!