I run this Procedure :
set serveroutput on ;
declare
c utl_tcp.connection;
begin
c := utl_tcp.open_connection(remote_host => '192.168.1.10',remote_port => '5550');
DBMS_OUTPUT.put_line('Connection Opened');
end ;
I got :
Error report -
ORA-04067: not executed, package body "SCOTT.UTL_TCP" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SCOTT.UTL_TCP"
ORA-06512: at line 5
04067. 00000 - "not executed, %s does not exist"
*Cause: Attempt to execute a non-existent stored procedure.
*Action: Make sure that a correct name is given
I already run command on sys as sysdba
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'UTL_TCP.xml',
description => 'ACL for utl_smtp package',
principal => 'SCOTT',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL
);
COMMIT;
END;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'UTL_TCP.xml',principal => 'SCOTT', is_grant => TRUE,privilege => 'connect');
COMMIT;
END;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'UTL_TCP.xml',
host => '*'
);
COMMIT;
END:;
GRANT EXECUTE ON utl_tcp TO SCOTT;
whats is the error ?