Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Calling table functions using named notation returns ORA-00907 (Oracle 9i)
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