Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!j72g2000cwa.googlegroups.com!not-for-mail
From: "Jun" <frankjunli@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Select into problem
Date: 12 Dec 2006 13:32:50 -0800
Organization: http://groups.google.com
Lines: 16
Message-ID: <1165959170.864410.152910@j72g2000cwa.googlegroups.com>
NNTP-Posting-Host: 209.91.162.170
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1165959176 15313 127.0.0.1 (12 Dec 2006 21:32:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 21:32:56 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: j72g2000cwa.googlegroups.com; posting-host=209.91.162.170;
   posting-account=Ddn9mwwAAAAfOYHSrAIgxocRVv6uVMft
Xref: usenetserver.com comp.databases.oracle.server:419051
X-Received-Date: Tue, 12 Dec 2006 16:32:56 EST (text.usenetserver.com)

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