Path: news.netfront.net!ctu-peer!ctu-gate!news.nctu.edu.tw!newsfeed.stanford.edu!postnews.google.com!k39g2000hsf.googlegroups.com!not-for-mail
From: chris.damsgard@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: ORA-00907 missing right parenthesis problem
Date: Fri, 4 Jan 2008 09:30:08 -0800 (PST)
Organization: http://groups.google.com
Lines: 23
Message-ID: <e6ff2944-5865-4d45-a5d9-688878c6fa77@k39g2000hsf.googlegroups.com>
References: <91ee1850-ecaf-4b7c-897f-5569611b13db@1g2000hsl.googlegroups.com> 
 <7d175a6d-75b9-4d5a-8853-de3b2910e127@y5g2000hsf.googlegroups.com> 
 <28c3a76c-d78e-485b-9bd0-1372dfa4899a@d21g2000prf.googlegroups.com> 
 <1199427313.219296@bubbleator.drizzle.com>
NNTP-Posting-Host: 146.217.200.214
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1199467808 7532 127.0.0.1 (4 Jan 2008 17:30:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 4 Jan 2008 17:30:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k39g2000hsf.googlegroups.com; posting-host=146.217.200.214; 
 posting-account=5qso0goAAADDC1N-GBUOKG1bHbX0idMb
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2),gzip(gfe),gzip(gfe)
Xref: news.netfront.net comp.databases.oracle.misc:66735

isi is the schema
net_gap_op_log is the package
getgapbucketsdefn() is the procedure.

It just returns a ref cursor.

I am using call because of the software that I am trying to get the
ref cursor data into.

The other procedure I mentioned (parse_external_key) takes a period
delimited string and parses out the values for me.

So, 34.63.29.14.84.26 would parse to:

34
63
29
14
84
26

But the main problem is that I can't get that ref cursor back from
these procedures (even when no input parameters).