Pork C

Greenhorn
+ Follow
since Jun 05, 2001
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Pork C

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.