Re: DBMS_PIPE.SEND_MESSAGE

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Thu, 06 Mar 2003 09:55:59 -0700
Message-ID: <3E677D9F.A1A5884F@noaa.gov>

Donna -

You don't mention an Oracle version, and the implementation of dbms_pipe between versions may not even have changed, but my spec for this function (my version if 8.1.7) says this:

DBMS_PIPE.SEND_MESSAGE (

    pipename     IN VARCHAR2,
    timeout      IN INTEGER DEFAULT MAXWAIT,

    maxpipesize IN INTEGER DEFAULT 8192)   RETURN INTEGER; Thus, what you're actually modifying is the timeout for the pipe, and not the maxpipesize.

I don't have a great deal of experience with pipes, but I'm fairly familiar with them, and I've gotten them to perform quite well for me. Contact me personally if there are some minor issues that I can address.

Thanks,
TG

Donna wrote:

> How do you change dbms_pipes using send_message function to
> increase the maxpipesize to a specific size. Documentation reflects
> that the maxpipesize is in bytes but when I use the following syntax
> the size increases but not to what I specificied. For example,
>
> select dbms_pipe.send_message('testpipe',51984) from dual
>
> changes the size to "1101" instead of "51984"??
>
> Does anyone have experience with this?
>
> Thanks in advance
> Donna
Received on Thu Mar 06 2003 - 10:55:59 CST