Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Tue, 12 Dec 2006 14:26:58 -0800 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Select into problem References: <1165959170.864410.152910@j72g2000cwa.googlegroups.com> In-Reply-To: <1165959170.864410.152910@j72g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1165962419.118078@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 29 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:419071 X-Received-Date: Tue, 12 Dec 2006 17:26:59 EST (text.usenetserver.com) Jun wrote: > Hi Guys, > > I have a question about PL/SQL code > > I have the following select into statement : > > SELECT STUD_AGE INTO v_cHP_MaxAge FROM STUDENT WHERE GDU = > '015346001002'; > > I know It has no value returned but it give a no_data_found error. > How do I escape that error without using exception? > Is there any way to force the query return some value instead of an > error? > > Thanks in advance Why would you want to circumvent the normal exception handling mechanism. If nothing is returned what do you want to result to be? That v_cHP is NULL or has some other value? Do you want processing to just continue? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org