Home » Developer & Programmer » JDeveloper, Java & XML » loading java source files
loading java source files [message #366750] Wed, 22 November 2000 23:26 Go to next message
Anandhi Jude
Messages: 3
Registered: September 2000
Junior Member
Iam a beginner trying to load java source into the database.
the following is the code

create java souce named "test" as
public class test{
public static void test_str(){
System.out.println " hello world";
}
}

to write the call spec should i publish this java source as procedure or function?

i want to create a procedure and output the string using an "out " parameter.how do i do that?

i created a procedure

create procedure p1 as
language java name 'test.test_str()';

when i call the procedure ,i get the following message

call completed

but the string is not displayed on the screen.

thanks in advance.
Re: loading java source files [message #366759 is a reply to message #366750] Tue, 28 November 2000 10:20 Go to previous message
T. Nguyen
Messages: 5
Registered: November 2000
Junior Member
To display the string on the screen, use the follow commands:

SQL> SET SERVEROUTPUT ON
SQL> CALL dbms_java.set_output(2000);

Then call your procedure.

Good Luck
T. Nguyen
Previous Topic: Unkown service name
Next Topic: a program of java about dbms_java.grant_permission
Goto Forum:
  


Current Time: Fri Mar 29 00:40:03 CDT 2024