Re: Loadjava from a client

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 27 Nov 2002 19:27:14 +0300
Message-ID: <as2rt8$3ch$1@babylon.agtel.net>

In SQL*Plus:

SQL> SET SERVEROUTPUT ON SIZE 20000
SQL> CALL DBMS_JAVA.SET_OUTPUT(20000);
SQL> EXEC yourJavaStoredProcedure(param, param, ....)

This is documented in Java Developer's Guide, "Invoking Java in the Database" chapter, "Redirecting Output on the Server" paragraph.

hth.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Simon Harvey" <ReplyToGroup_at_thanks.com> wrote in message news:R96F9.9304$dz2.1265669_at_stones...


> Hi again,

> 

> The code that I've loaded into the database is:

> 

> 

> public class HelloWorld {

> 

>   public static void hello(){

>     System.out.println("Hello World");

>   }

> 

> }

> 

> Maybe I'm being a bit silly here because Im actually not 100% sure that the

> source should print out to the screen. But thats what I was expecting. If I

> run it in sql++, what should it do? All im getting it PL/SQL procedure

> completed successfully!

> 

> Doesnt seem to successfull at the moment!: (

> 

> Simon

> 

>

Received on Wed Nov 27 2002 - 10:27:14 CST