How to echo error from foreach loop?

How to use loadjava with oracle 10g. Error message?

• I want to use loadjava for Java Stored Procedure on Oracle 10g. The loadjava.bat file was not available in my installation directory so I copied it from oracle 9i. But when I tried to run the loadjava command from cmd its giving below error:- The Device is not ready. I tried to run loadjava in debug mode(set DBG=echo) which gave below output:- LOOP- (loop for args parsing) MARK6 hit (append classpath) MARK7 hit (append addclasspath) MARK8 hit (append resolver) MARK9 hit (invoke loadjava) *** CLASSPATH = *** *** addclasspath = *** *** jreclasspath = "C:\Users\Toshiba\Desktop\loadj\orai18n.… Desktop\loadj\rt.jar;C:\Users\Toshiba\… r;C:\Users\Toshiba\Desktop\loadj\javax… :\Users\Toshiba\Desktop\loadj\classes1… *** *** javaprops = "-Xint" *** *** rslvarg = *** *** args = *** The device is not ready. Please help me to resolve this problem.

• Answer:

  The loadjava tool is in your Oracle bin directory, which must be in your path in order to use any command line tool such as sqlplus. You should definitely NOT copy it from another Oracle version. However you are probably using the free Express edition which does not come with Java support and so does not come with the loadjava tool. Even if you could get it to work (which you cannot), you will not be able to run the result since your database does not include any JVM. Assuming that this is for evaluation, development and testing, you are allowed to download a full edition of Oracle (SE, EE) which comes with full Java support.