Re: How to Use DBMS_PIPE

Anil Sam wrote:
>
> I am trying to use DBMS_PIPE. Whenever I give the following commands from
> SQL prompt I get the following error message. If anybody aware how to
> overcome this problem, please let me know.
>
> select dbms_pipe.create_pipe('Tapas') from dual;
>
> ORA-06571: Function create_pipe does not gurantee not to update the
> database.
> Whenver I try to use any function it come up with the same error.
>
> Thanx
> Tapas

Rather than use it within an SQL statement, do it within PL/SQL.

eg

declare
  x number;
begin
  x := dbms_pipe.create_pipe('Tapas');
  (etc)
end;

The problem with using ANY packaged procedure in SQL is that Oracle cannot
tell if the proc within the package will do anything nasty - for example,
like updating the table that you are selecting from!.

This can be overcome by using pragma's within the package spec.

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin