Skip to main content

All Questions

0 votes
2 answers
4k views

java.sql.SQLSyntaxErrorException: ORA-01729: database link name expected while using Java stored procedure

I have created a java stored procedure in Oracle, using query: CREATE OR REPLACE PROCEDURE GETSHEETROWS(I_file_id number, I_sheetNode clob,template_key varchar2 ,wksht_key varchar2 ,wksht_name ...
Ravi Shankar's user avatar
2 votes
1 answer
2k views

Getting PLS-00258 when creating PL/SQL wrapper function for Java method

I've got the following Java method (which I've loaded into an Oracle 11g database from its JAR using loadjava) public int GatewayClientPoolHA( String[] DAUTAddresses, int[] DAUTPortArray, ...
J Dor's user avatar
  • 327
3 votes
1 answer
597 views

Oracle Java stored librairies won't compile

I'm looking to store Java libraries inside my Oracle database. Note that this is the first time I'm doing that. That library is pd4ml. It is made up of two jars, which contains the compiled classes. ...
tdtm's user avatar
  • 336
1 vote
6 answers
11k views

Confusion over class resolution in Oracle java stored procedures

I'm trying to use a third-party java library within oracle. The library seems compatible with the same 1.4 version of the jvm that our Oracle 10g server hosts, since it runs fine outside of Oracle, ...
Chris Farmer's user avatar
  • 25.5k