EBS: JAVA SOURCE创建后再查看源代码

 

EBS : JAVA SOURCE创建后再查看源代码

DECLARE CURSOR C1 IS 
SELECT US.NAME, TYPE, LINE, TEXT 
  FROM USER_SOURCE US 
  WHERE 1=1
   AND NAME LIKE 'HELLO'  -- JAVA源名称 
   AND TYPE LIKE 'JAVA SOURCE'-- SOURCE'
   ORDER BY NAME,TYPE,LINE;
BEGIN
  DBMS_OUTPUT.PUT_LINE('create or replace and compile java source named '|| 'HELLO' ||' as ');
  FOR R1 IN C1 LOOP
    DBMS_OUTPUT.PUT_LINE( R1.TEXT);
  END LOOP;
END;