Re: Querying devices via SNMP from stored procedure

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 Jan 2005 06:24:04 -0800
Message-ID: <1105453444.436355.43900@f14g2000cwb.googlegroups.com>

John Leslie wrote:
> Does oracle provide any packages to run snmp queries againgst SNMP
> enabled network devices like printers etc from a stored
> procedure(java/plsql)?

I don't think you can do this in pure PL/SQL. Your best bet may be Java since Oracle (from 8i onwards) has a built in Java engine inside the database. Maybe you should google in comp.lang.java.* to see if there are any Java API's for SNMP.

Simple explanation to use Java in Oracle is that you write/compile your Java class using JDK. Load it in Oracle using LoadJava and then write a PL/SQL wrapper function to call the Java stored procedure. Regards
/Rauf Received on Tue Jan 11 2005 - 08:24:04 CST