Solved

STORED PROCEDURE

Posted on 2007-04-04
3
832 Views
Last Modified: 2012-08-13
CREATE OR REPLACE PROCEDURE host_command (p_command  IN  VARCHAR2)
AS LANGUAGE JAVA
NAME 'Host.executeCommand (java.lang.String)';


I can create a JAVA STORED PROCEDURE in Oracle using the above in Oracle..Is there any way to create something as below
CREATE OR REPLACE PROCEDURE host_command (p_command  IN  VARCHAR2)
AS LANGUAGE VISUAL BASIC
NAME 'Host.executeCommand (java.lang.String)';
0
Comment
Question by:suhinrasheed
3 Comments
 
LVL 8

Accepted Solution

by:
gvsbnarayana earned 250 total points
ID: 18849288
Visual Basic compiler is not yet included into Oracle core programmes and it's not expected even.
You can create stored procedures in only using Java
HTH
Regards,
Badri.
0
 
LVL 27

Assisted Solution

by:sujith80
sujith80 earned 200 total points
ID: 18849493
External procedures can be written in either C or Java. In a windows environment, You can call a dll using this method.

The following links will be of help.

http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_extern_proc.htm#ADFNS010
http://www.unix.org.ua/orelly/oracle/prog2/ch21_01.htm
0
 
LVL 22

Assisted Solution

by:Ivo Stoykov
Ivo Stoykov earned 50 total points
ID: 18849564
Hello suhinrasheed,

you cannot, but you could use external program to handle what you need...

Regards,

ivostoykov
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now