Native SQL statements (and/or PL/SQL)

From: Atish Kumar <akumar_at_yallara.cs.rmit.edu.au>
Date: 1998/11/25
Message-ID: <73h773$8vf$1_at_emu.cs.rmit.edu.au>#1/1

[Quoted] I cannot seem to see anything in the JDBC spec that allows me to talk natively to the database, and get the result perhaps as probably as say an AsciiStream.

ResultSet results;
try {

    results = stmt.executeQuery("declare

        help varchar(20):='help';
        begin
            help := help ||  ' world';
            DBMS_OUTPUT.PUTLINE(help);
        end;
       ")

} catch (Exception e){

 System.out.println(e);
}

and be able show this? Can anyone suggest I way I can do this in Java, make native (PL/) SQL code?

Atish

-- 
Eats code, sleeps with OO, dreams of Patterns -- and still mutually exclusive
While the rest of the days go by teaching
HomePage	: http://yallara.cs.rmit.edu.au/~akumar 
Phone       : (613) 95720607 or 0414779733 (61414779733 for intl.)
(NEW on-line resume also available, do you need an expert for soft/net. devel.?)

Received on Wed Nov 25 1998 - 00:00:00 CET