Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Calling table functions using named notation returns ORA-00907 (Oracle 9i)

Calling table functions using named notation returns ORA-00907 (Oracle 9i)

From: Lambros Papadopoulos <lambros_at_ctl.com.cy>
Date: Mon, 20 May 2002 17:52:41 +0300
Message-ID: <3ce90a3e_4@corp.newsgroups.com>

Calling the table function t:

Select * from table(t('new'));

works fine.

Calling

Select * from table(t(status => 'new'));

returns

ORA-00907: missing right parenthesis

before the equal sign.

Any ideas, workarounds?

Lambros

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon May 20 2002 - 09:52:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US