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@po8ir3 -resolve D:\Dba.java
D:\>
D:\>sqlplus scott/tiger@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@o8ir3::SQL>CREATE OR REPLACE PROCEDURE printHello
2 AS LANGUAGE JAVA
3 NAME 'Dba.printHello()';
4 /
Procedure created.
scott@o8ir3::SQL>set SERVEROUPUT ON;
SP2-0735: unknown SET option beginning "SERVEROUPU..."
scott@o8ir3::SQL>set serveroutput on
scott@o8ir3::SQL>CALL dbms_java.set_output(1000);
Call completed.
scott@o8ir3::SQL>call printHello();
Hello World
Call completed.
scott@o8ir3::SQL>
*** =====>>> BUT when I select from v$option Oracle says 'Java=False' (as follows).
Why ? What
it means ? The java entry refers to Java Server, or another java-related tool ?
[]s
Chiappa
scott@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@o8ir3::SQL>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: J. Laurindo Chiappa
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
