DBMS_PIPE Experts ! Help !^%$%
Date: 19 Oct 1994 10:56:14 GMT
Message-ID: <382u0f$5qj_at_raffles.technet.sg>
Does anyone out there have some SOLID code that really works ??? The Oracle code's fraught with errors and I can't get DBMS_PIPE to work. For example:
Does anyone know why the following code when compiled comes out with errors. Afterall, it was in the Application Developer's Guide:A-23
create or replace procedure DEBUG (info varchar2) is
return_val integer;
begin
execute DBMS_PIPE.PACK_MESSAGE(info);
return_val := DBMS_PIPE.SEND_MESSAGE('plsql_debug');
if return_val <> 0 then
RAISE_APPLICATION_ERROR(-2000, 'Debug Error');
end if;
end;
/
show errors procedure DEBUG;
exit;
The errors are listed below:
Connected to:
ORACLE7 Server Release 7.0.16.4.0 - Production
With the procedural, distributed, and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
Warning: Procedure created with compilation errors.
Errors for PROCEDURE DEBUG:
LINE/COL ERROR
-------- ----------------------------------------------------------------- 4/5 PLS-00201: identifier 'DBMS_PIPE' must be declared 4/5 PL/SQL: Statement ignored 5/5 PL/SQL: Statement ignored 5/19 PLS-00201: identifier 'DBMS_PIPE' must be declaredDisconnected from ORACLE7 Server Release 7.0.16.4.0 - Production With the procedural, distributed, and Parallel Server options PL/SQL Release 2.0.18.1.0 - Production
Even the PRO*C part of the example has got errors when I compile it. It tells me that the pointers can't be assigned in the way the Oracle Manual said it could !!!
What I really like about this newsgroup is that I can get good answers. What I don't like is that ORACLE gets really SLOPPY with its code examples and expects the ORACLE community to support itself !!! Received on Wed Oct 19 1994 - 11:56:14 CET