Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Doubt about java in 8i

Doubt about java in 8i

From: J. Laurindo Chiappa <jlchiappa_at_uol.com.br>
Date: Mon, 12 Feb 2001 17:48:36 -0800
Message-ID: <F001.002B215A.20010212172041@fatcity.com>

Hi ! I'm beginnig to test the Java/JavaStoredProcs options in a 8ir3 Personal database.  I can create and exec a JSP, as it :

D:\>type Dba.java
// Dba.java
// Save the file with the same name as the public class

import java.util.*;
public class Dba
{
public static void printHello ()
{
String prtString="Hello World";
System.out.println(prtString);
}
}

D:\>loadjava -u scott/tiger_at_po8ir3 -resolve D:\Dba.java

D:\>
D:\>sqlplus scott/tiger_at_po8ir3

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Feb 12 16:33:06 2001

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Personal Oracle8i Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

scott_at_o8ir3::SQL>CREATE OR REPLACE PROCEDURE printHello   2 AS LANGUAGE JAVA
  3 NAME 'Dba.printHello()';
  4 /

Procedure created.

scott_at_o8ir3::SQL>set SERVEROUPUT ON;
SP2-0735: unknown SET option beginning "SERVEROUPU..." scott_at_o8ir3::SQL>set serveroutput on
scott_at_o8ir3::SQL>CALL dbms_java.set_output(1000);

Call completed.

scott_at_o8ir3::SQL>call printHello();
Hello World

Call completed.
scott_at_o8ir3::SQL>

[]s

    Chiappa

scott_at_o8ir3::SQL>select * from v$option;

PARAMETER                           VALUE
----------------------------------- ----------------------------------------
Partitioning                        TRUE
Objects                             TRUE
Parallel Server                     FALSE
Advanced replication                TRUE
Bit-mapped indexes                  TRUE
Connection multiplexing             TRUE
Connection pooling                  TRUE
Database queuing                    TRUE
Incremental backup and recovery     TRUE
Instead-of triggers                 TRUE
Parallel backup and recovery        TRUE
Parallel execution                  TRUE
Parallel load                       TRUE
Point-in-time tablespace recovery   TRUE
Fine-grained access control         TRUE
N-Tier authentication/authorization TRUE
Function-based indexes              TRUE
Plan Stability                      TRUE
Online Index Build                  TRUE
Coalesce Index                      TRUE
Managed Standby                     TRUE

PARAMETER                           VALUE
----------------------------------- ----------------------------------------
Materialized view rewrite           TRUE
Materialized view warehouse refresh TRUE
Database resource manager           TRUE
Spatial                             TRUE
Visual Information Retrieval        TRUE
Export transportable tablespaces TRUE Transparent Application Failover TRUE
Fast-Start Fault Recovery           TRUE
Sample Scan                         TRUE
Duplexed backups                    TRUE
Java                                FALSE
OLAP Window Functions               TRUE

33 rows selected.

scott_at_o8ir3::SQL>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: J. Laurindo Chiappa
  INET: jlchiappa_at_uol.com.br

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Feb 12 2001 - 19:48:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US