Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    45

    Unanswered: Java and public class

    Hi,

    How does one load/run or create this function in Oracle8i 8.1.7?

    Public class SSconstants {
    Public static int SSthresh ()
    {
    return 64500;
    }
    }


    Do I run this statement from the SQL> prompt?

    $loadjava –user john/john@local -verbose SSconstants.java

    That one I got and the rest I got.

    create or replace function SSthresh return number as
    language java name ‘SSconstants.SSthresh() return int’;

    Select SS_thresh from dual;

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: Java and public class

    Originally posted by alexxx15
    Hi,

    How does one load/run or create this function in Oracle8i 8.1.7?

    Public class SSconstants {
    Public static int SSthresh ()
    {
    return 64500;
    }
    }


    Do I run this statement from the SQL> prompt?

    $loadjava –user john/john@local -verbose SSconstants.java

    That one I got and the rest I got.

    create or replace function SSthresh return number as
    language java name ‘SSconstants.SSthresh() return int’;

    Select SS_thresh from dual;
    Hi,

    You could use create or replace java source.

    Hope it Helps
    nn

  3. #3
    Join Date
    Mar 2003
    Posts
    45
    How does one do "create or replace java source"?

  4. #4
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107
    Originally posted by alexxx15
    How does one do "create or replace java source"?
    Hi,

    CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED SSconstants AS
    import java.io.*; /* In Case u need it */
    public class SSconstants
    {
    public static int SSthresh()
    {
    return 64500;
    }
    }
    /

    Hope it Helps
    PS: you have to run this on SQL*Plus
    Last edited by NoviceNo1; 05-08-03 at 13:04.
    nn

  5. #5
    Join Date
    Mar 2003
    Posts
    45
    Thanks. That is going to help me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •