ORA-00999

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Feb 2007 10:33:25 -0800
Message-ID: <1172255605.776958@bubbleator.drizzle.com>

Just found something without a single reference at metalink or that I can find using google.

Can anyone explain what is happening here?

SQL> CREATE OR REPLACE PACKAGE test AS

   2 FUNCTION myfunc( args ...) RETURN VARCHAR2;    3 END test;
   4 /

Package created.

SQL> CREATE OR REPLACE FUNCTION myfunc(args ...) RETURN VARCHAR2 AS

   2 BEGIN
   3 RETURN 'A';
   4 END;
   5 /

Warning: Function created with compilation errors.

SQL> sho err
Errors for FUNCTION DUMMY:

LINE/COL ERROR

-------- -----------------------------------------------------------------
1/16     PLS-00999: implementation restriction (may be temporary) 

ellipsis not allowed in this context

SQL> What is the meaning of (args ...) as an input parameter?

And lest you think it invalid syntax ... check out /rdbms/admin/utllms.sql

I am trying to figure out what the UTL_LMS package header means.

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Feb 23 2007 - 12:33:25 CST