• Post Reply Bookmark Topic Watch Topic
  • New Topic

Creating Pl/Sql Function from java

 
jagan raja
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have created a function from java using prepare statement. And this works fine.

The below is just a snippet. I have got the function as below. It works fine.




Now I have to check if that function exists prior to the creation from java.

How can i do that?

Can anyone help me out???
 
Amit Vinod Dali
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can run sql (using jdbc) on the database system tables e.g. "DBA_OBJECTS" (req. admin users) which contains the metadata (related to function, procedure, tables etc).

Oracle System Tables are as; (Assuming you are using oracle database)
Oracle System Tables
 
jagan raja
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your suggestion..............
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!