Win a copy of Head First Android this week in the Android forum!

manvendra singh

Greenhorn
+ Follow
since Feb 05, 2011
manvendra likes ...
Hibernate Eclipse IDE Spring
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 manvendra singh

M trying to call my java class function as pl sql function..

I dont have databse at my local machine....using sqldeveloper for database access.

So to load my java class I am using Load Java option mentioned in Java section in sqldeveloper.
My Class have a stand alone logic and have no dependencies...
I am using this java in Oracle option first time ....
Please suugest if I am making any silly mistake.

I am getting following exception when pressing apply after giving the source in source_tab and and same name as class name in Name_tab.


the class I am trying to compile is........





when I try to view my object status in DB, all my attempts are at invalid status

SELECT OBJECT_NAME, OBJECT_TYPE, STATUS
FROM USER_OBJECTS
WHERE OBJECT_TYPE IN ('JAVA SOURCE', 'JAVA CLASS', 'JAVA RESOURCE')
ORDER BY OBJECT_TYPE, OBJECT_NAME;

MorpherLast JAVA CLASS INVALID
TextMorpher JAVA CLASS INVALID
TextMorpher1 JAVA CLASS INVALID
MorpherLast JAVA SOURCE INVALID
TextMorpher JAVA SOURCE INVALID
TextMorpher1 JAVA SOURCE INVALID

I am even not able to drop these wrong compile Object from DB..............
.................
Please help.
Doesn't matter whether its a clob or varchar in database...
You can consider it as String in your java code.........
(provided you are not using updatable resultset)


happy Coding
Hi All,
I had a requirement to morph CreditCard information present in a legacy Database for last 14 years.

I tried to do it in java and have written following code for that.
based upon updatable resultset.
But its performance is very poor.



Class DB Access looks like



Can somebody please tell some optimization in it without writing a stored procedure.......

And even above rs.updateString() method throws an obvious exception Internal (Error: Unable to construct a Datum from the specified input) when operating with clob.
So can anyone please tell that how to create a clob object to pass to rs.updateClob(1,txtClob)....