Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting NEXTVAL out of SYS.JOBSEQ
login as sys (or internal)
GRANT SELECT ON JOBSEQ TO your_user
copile again and run
Oscar Zamora
Oracle DBA
"Joe" <Joe_at_foo.com> wrote in message
news:ad8ek5$ui9sc$1_at_ID-87429.news.dfncis.de...
>
> 8.1.6 EE on Windows 2000
>
>
> While logged in as JOE (has CONNECT, RESOURCE, DBA GRANTed), I
> can execute
>
> SELECT SYS.JOBSEQ.NEXTVAL FROM DUAL;
>
>
> ... in SQL*Plus, but when I do the same in a PL/SQL procedure:
>
>
> CREATE OR REPLACE FUNCTION XXX RETURN NUMBER AS
>
> XSEQUENCE NUMBER;
>
> BEGIN
>
> SELECT
> SYS.JOBSEQ.NEXTVAL INTO XSEQUENCE
> FROM
> DUAL;
>
> RETURN XSEQUENCE;
>
> END;
>
>
>
> ...I get:
>
> PLS-00201: identifier 'SYS.JOBSEQ' must be declared.
>
>
> Question: how can I get the value of SYS.JOBSEQ.NEXTVAL in my
> PL/SQL code?
>
>
>
>
Received on Fri May 31 2002 - 13:53:40 CDT