Hi,
It will very helpful if someone could guide me with this problem.
I am trying to execute a java stored procedure in Oracle Lite
local database. For example...
1. After creating and loading the java class. I create the procedure as follows.
CREATE OR REPLACE PROCEDURE drop_it (
obj_type VARCHAR2,
obj_name VARCHAR2)
AS LANGUAGE JAVA
NAME 'GenericDrop.dropIt(java.sql.Connection,
java.lang.String, java.lang.String)';
2. When I finally execute the following SQL
SELECT drop_it('TABLE','testTable')
FROM dual
Expected result doesn't come only the following exception
Exception in thread "main" java.sql.SQLException: [POL-8035] no such attribute or method.
But in the case of java stored procedure without any SQL connection, I am able to excecute the it without any exception.
Thanks in Advance..
Pork.