• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 846
  • Last Modified:

STORED PROCEDURE

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
suhinrasheed
Asked:
suhinrasheed
3 Solutions
 
gvsbnarayanaCommented:
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
 
sujith80Commented:
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
 
Ivo StoykovCommented:
Hello suhinrasheed,

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

Regards,

ivostoykov
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now