SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SPOOL c:/myheart.TXT;
SELECT decode(line,1,'create or replace '||TEXT,text) FROM USER_SOURCE WHERE TYPE = 'PROCEDURE'
AND NAME IN( SELECT OBJECT_NAME FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE');
spool off;
SET ECHO ON;
SET FEEDBACK ON;
SET HEADING ON;
SET FEEDBACK OFF;
SET HEADING OFF;
SPOOL c:/myheart.TXT;
SELECT decode(line,1,'create or replace '||TEXT,text) FROM USER_SOURCE WHERE TYPE = 'PROCEDURE'
AND NAME IN( SELECT OBJECT_NAME FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE');
spool off;
SET ECHO ON;
SET FEEDBACK ON;
SET HEADING ON;
Calling external procedure with Java or C language program
Oracle provide a JVM to processing Java class ,and call external program directly, writing
the detailed method to call external Java class and C language program in database. Take a
example to describe it.
Hint: First of all ,configure tnsnames.ora file and listener.ora ,then prepare external procedures,
use create [or replace] library library_name {is|as} 'file_name_and_path' to create library, grant
execute on <library_name> to <user/public>;
Use the SQL statement
create [or replace] procedure [schema.]procedure_name
as
name <exdll_inner_subroutine_name>
language C
library lib_name
[with context][parameters (parameters)]
or
create [or replace] procedure [schema.]procedure_name
as
language Java name ('string')
to create external procedures.
The last step is to call and execute external procedure.
Requirement:
Write the principle and detailed procedures/steps, add the necessary illustration
and screen copy using screen coping software. Shrinking graph size in the report.