tag:blogger.com,1999:blog-18037024.post115433584484483701..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: ORA-21779 the brain teaserByte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-18037024.post-5108455895893628752009-08-25T12:17:36.963+02:002009-08-25T12:17:36.963+02:00I have it in 9.2.0.6.0 in the context of pipeline ...I have it in 9.2.0.6.0 in the context of pipeline functions ...xhttps://www.blogger.com/profile/10767649978835225214noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-44249754442522728002007-09-27T16:22:00.000+02:002007-09-27T16:22:00.000+02:00I don't know if ORA-21779 is bound to a single cir...I don't know if ORA-21779 is bound to a single circumstance, i mean, it could well be a generic "hat" for a variety of buffer/memory related issues.<BR/><BR/>I mean, if you take ORA-01428, it's a generic error message for an invalid value, but is not specific to any function, so, who knows if ORA-21779 belongs to this category.<BR/><BR/>Thank you,<BR/>FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-91221793638679903652007-09-25T00:32:00.000+02:002007-09-25T00:32:00.000+02:00I get the sodding thing while using utl_smtp. May ...I get the sodding thing while using utl_smtp. May well be that a regexp_replace is buried in there. Code is wrapped though so I don't know.<BR/><BR/>Seems that if for some reason the previous connection to the mail server without closing_data and connection the <I>next</I> connection gets the duration not active error.<BR/><BR/>What really Bugs me is that I can't seem to:<BR/>a. trap the error. Tony Reedhttps://www.blogger.com/profile/18242597617251920464noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-7413064109346123862007-07-04T14:23:00.000+02:002007-07-04T14:23:00.000+02:00We had the same problem.Trouble is IMHO exception ...We had the same problem.<BR/>Trouble is IMHO exception handling in Oracle Pl/Sql<BR/><BR/>-- what we did and what caused trouble:<BR/><BR/> BEGIN<BR/> <BR/> SELECT titel<BR/> INTO this_titel<BR/> FROM lib_titel<BR/> WHERE titel_nosymbol = p_nosym;<BR/><BR/> EXCEPTION<BR/> WHEN no_data_found<BR/> THEN<BR/> RETURN trim(initcap(regexp_replace(Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-82471486387499338382007-07-04T12:13:00.000+02:002007-07-04T12:13:00.000+02:00Happens for me on Windows and Linux. NOT on Mac OS...Happens for me on Windows and Linux. NOT on Mac OS X 10.4.10Anonymousnoreply@blogger.com