Xref: alice comp.databases.oracle.misc:22514
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!204.71.1.48!spamkiller1.cwix.com!pm01nn!not-for-mail
From: "Miles Palmer" <miles.palmer@mci.com>
Subject: Oracle Function NOT returning value
Newsgroups: comp.databases.oracle.misc
Message-ID: <01be0dd0$ab4d6f90$a70225a6@mpalmer>
X-Newsreader: Microsoft Internet News 4.70.1161
Lines: 13
Date: Thu, 12 Nov 1998 01:18:06 GMT
X-Trace: pm01nn 910833486 166.37.2.167 (Thu, 12 Nov 1998 01:18:06 GMT)
NNTP-Posting-Date: Thu, 12 Nov 1998 01:18:06 GMT
Organization: CWIX

I just created my first Oracle(8) function and it compiles fine. The only
problem is that when I run it, I get back an ORA message saying that the
function did not return a value. Just to be safe, I stripped out all the
code except one line to put a CHAR value in the return variable....Same
problem.

I am doing this by the book and I am stumped...Any ideas??

Thanks in advance.

Miles Palmer
MCIWorldcom
719-535-1295