I read the little blurb in the 9i new features on it. The example there doesnt seem
very useful. What have people used it for?
any good articles with good examples on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Ryan,
I use it extensively ... for some of the utilities I wrote for application support ...
here is one sample ...
This utility shows errors in the pl/sql code, what's different is not only it shows
the errors, but also shows the source lines and exact location of the error.
To test, install
Subject
anyone use pipelined functions?
I read the little blurb in the 9i new features on it. The example there
doesnt seem very useful. What have people used it for?
any good articles with good examples on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each would be interesting to see.
Jared
[EMAIL PROTECTED]
Sent
[EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each
PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each would
:
Subject:Re: anyone use pipelined functions?
In the interests of documentation, and if I have time, I could engineer a
similar 'dumb' procedure, perform trace as each modification is made, and
post the results here. It's pretty easy to come up with an artificial
routine, though, to do
recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes
]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
That would be cool if you have time for it.
Re the sequence: is it assigned in a trigger, or directly in the SQL?
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:19
My responses below are below
Ryan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:54 AM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
great response. questions inline
My responses below are below -- sigh, it's been a long day. lol
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 01:59 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
My responses
Title: Pipelined functions
Yes, I sent out another message shortly after that 'set arraysize 1' was
the key.
Thanks
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
Title: Pipelined functions
I have a question related to pipelined functions ...
I have a function which performs a task in a loop. I have piped messages at the beginning and end of the loop and expect them to appear as soon as they are piped. But there seems to be a difference of opinion
Title: Pipelined functions
Hi!
How did you test it? From sqlplus or external app?
Then check whether you have array processing turned on (it should be off if you
want to get rows one-by-one).
Or if in PL/SQL, are you using bulk
collections?
Tanel.
- Original Message -
From
Title: Pipelined functions
Doh !!
Ijust figured it out .. "set
arraysize 1" was the missing link ... one guy replied to my posting on
forum://Metalink:oracle_plsql that it might be client side caching and that
prompted me to experiment with arraysize.
So, it was an issue wi
15 matches
Mail list logo