Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Call Java class from PL/SQL

reddisJun 13 2013 — edited Jun 17 2013

HI,

I am trying to call a java class from PL/SQL and I was successfully able to load the class file. But when I try to build the PL/SQL wrapper for the java class I am getting the below error.

The java class takes a character array as input.

CPA_CC_PAYMENT is an object. I am using Oracle 9i DB.

CREATE OR REPLACE PROCEDURE Cpa_Call_Ws(cc_payCPA_CC_PAYMENT) AS

LANGUAGE JAVA

NAME 'ChargeCard.main(oracle.sql.STRUCT)';

PL/SQL: Compilation unit analysis terminated

PLS-00311: the declaration of

"ChargeCard.main(oracle.sql.STRUCT)" is incomplete or malformed

I also tried oracle.sql.ARRAY as my input array but neither worked

Any help is appreciated.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2013
Added on Jun 13 2013
#9i, #java
4 comments
1,122 views