Home » Developer & Programmer » JDeveloper, Java & XML » Java Stored Procedure
Java Stored Procedure [message #92681] Mon, 22 November 2004 03:26 Go to next message
ROOPA
Messages: 3
Registered: August 2004
Junior Member
How can I see the source code of a java stored procedure?
Re: Java Stored Procedure [message #92689 is a reply to message #92681] Tue, 23 November 2004 19:45 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Here is an example:

create or replace java source named "Hello" as
        public class Hello {                             /* Pure Java Code */
                static public String Msg(String tail) {
                        return "Hello " + tail;
                }
        }
/


SQL> select text from user_source where name = 'Hello' order by line;

TEXT
--------------------------------------------------------------------------------
public class Hello {                             /* Pure Java Code */
                static public String Msg(String tail) {
                        return "Hello " + tail;
                }
        }


Best regards.

Frank
Previous Topic: Java.lang.noclassdeffounderror
Next Topic: OracleJSP: oracle.jsp.provider.JspCompileException:
Goto Forum:
  


Current Time: Fri Apr 19 08:37:06 CDT 2024