Hi,
Extract the source code for the procedure of function from the source database and execute it on the target database.
If you run on Oracle 9i and above, you can use DBMS_METADATA to extract the source code. Example:
SQL> SELECT dbms_metadata.get_ddl('PROCEDURE', 'HI', 'SCOTT') FROM dual;
DBMS_METADATA.GET_DDL('PROCEDURE','HI','SCOTT')
--------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE "SCOTT"."HI" AS
BEGIN
dbms_output.put_line('Hello world');
END;
Best regards.
Frank
] 
Blog
Search
Help
Members
Register
Login
Home
