Re: ORA-00907 missing right parenthesis problem
From: <chris.damsgard_at_gmail.com>
Date: Fri, 4 Jan 2008 09:30:08 -0800 (PST)
Message-ID: <e6ff2944-5865-4d45-a5d9-688878c6fa77@k39g2000hsf.googlegroups.com>
Date: Fri, 4 Jan 2008 09:30:08 -0800 (PST)
Message-ID: <e6ff2944-5865-4d45-a5d9-688878c6fa77@k39g2000hsf.googlegroups.com>
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). Received on Fri Jan 04 2008 - 11:30:08 CST