Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleµ÷ÓÃjava·½·¨´íÎó - Oracle / ¿ª·¢

oracleµ÷ÓÃjava·½·¨´íÎó: ORA-29541: ÎÞ·¨½âÎöÀà.

¹ý³ÌÈçÏÂ: 
 1.Ê×ÏÈÎÒ×öÁËн¨ÁËÒ»¸ö²âÊÔµÄÏîÄ¿,ÀïÃæ¾ÍÖ»ÓÐÒ»¸öµ¥¶ÀµÄMain²âÊÔÀà. ÀïÃæÓÐÒ»¸ö·½·¨:
public static String sayHello(String name){
  return " hello " + name;
}
 2.È»ºó°ÑÏîÄ¿´ò°ü³Éprj.jar.
  ÎÒÓÃloadjava -user sys/sys@databaseName prj.jar 
select DBMS_JAVA.LONGNAME(OBJECT_NAME) as OBJECT_NAME
  from USER_OBJECTS
 where OBJECT_TYPE like 'JAVA%'
 and object_name like '%Main'
ÒѾ­²éѯµ½Õâ¸öÀà.
 3.È»ºóÔÚoracleÖз¢²¼java³ÌÐò:
create or replace function hello (name VARCHAR2) return VARCHAR2 
  as language java name
  'Main.sayHello (java.lang.String) return java.lang.String ';
Ö´ÐÐ:
  select hello(' world! ') from dual;
Ìáʾ:ORA-29541: ÎÞ·¨½âÎöÀà SYS.Main.
ÇëÖ¸½Ì.

ÎÊÌâÊÇÎÒµ¼ÈëÁËjar°ü.È»ºóÔõô"ÉèÖÃ"²ÅÄÜÈÃÎÒÀ´ÒýÓÃÕâ¸ö°üÄØ?¡¡

¸øÄã¸öÀý×Ó£º
ÏÖÔÚ,10G¼°ÆäÒÔºó°æ±¾µÄOracleÊý¾Ý¿âÌṩÁ˶ÔJava³ÌÐòµÄ¸ü¶àµÄÖ§³Ö,ºÜºÃµÄ½â¾öÁËÕâ·½ÃæµÄÎÊÌâ. ½â¾ö·½·¨ÈçÏÂ,
1. Ê×ÏÈÎÒÃÇ´´½¨µ÷ÓòÙ×÷ϵͳÃüÁîµÄJava·½·¨
create or replace and compile java source named oscmd as
import java.io.*;
import java.lang.*;
public class OSCmd extends Object {
  public static int OSCmd(String args) {
  Runtime rt = Runtime.getRuntime();
  int rc = -1;
  try


Ïà¹ØÎÊ´ð£º

tomcat»·¾³ÏÂjsp±àÒë´íÎó£¬Çó½â£¡ - Java / Web ¿ª·¢

org.apache.jasper.JasperException: Unable to compile class for JSP: 
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......

c/sºÍb/sÖ®¼äÔõôͨѶ. - Java / Web ¿ª·¢

ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾­ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾ­Ìá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ