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 -> Re: Oracle error

Re: Oracle error

From: Patrice Castet <patrice.castet_at____nospaaaaam____in-fusio.com>
Date: Fri, 16 May 2003 12:45:20 GMT
Message-ID: <3ec4dd2a.365205640@read.news.fr.uu.net>


I don't understand why you have a ">" sign in your select clause ? It looks a lot a typing mistake ...
"... TO_CHAR(ESEQ>NEXTVAL)
SEQ_ORDER, ..." On 15 May 2003 12:46:53 -0700, mhakimjavadi_at_hotmail.com (Mohammad) wrote:

>Hi
>
>I'm spooling data to a file and using a sequence number generator to number
>each record and I get an ORA-02287 error. When I look up the error, it
>tells me this:
>
>ERROR at line 17:
>ORA-02287: sequence number not allowed here
>
>
>Here's my SQL:
>
>CREATE SEQUENCE ESEQ START WITH 1
>
>
>COLUMN FACULTY FORMAT A30
>COLUMN DEPARTMENT FORMAT A30
>COLUMN COURSE FORMAT A30
>COLUMN SECTION FORMAT A30
>COLUMN COMPONENT FORMAT A30
>COLUMN DELIVERY FORMAT A30
>COLUMN START_DATE FORMAT A30
>COLUMN END_DATE FORMAT A30
>COLUMN PATTERN FORMAT A30
>COLUMN SEQ_ORDER FORMAT A10
>COLUMN FREQUENCY_INTERVAL FORMAT A10
>COLUMN ACTIVE FORMAT A1
>
>SELECT SCBCRSE_COLL_CODE FACULTY,
> SCBCRSE_DEPT_CODE DEPARTMENT,
> RPAD( SSBSECT_SUBJ_CODE, 4 )
> || ' '
> || SSBSECT_CRSE_NUMB COURSE,
> SSBSECT_SEQ_NUMB SECTION,
> SSBSECT_CRN || SSRMEET_SCHD_CODE COMPONENT,
> DECODE(SSRMEET_CATAGORY,
> NULL,'01') DELIVERY,
> TO_CHAR(SSRMEET_START_DATE, 'YYYYMMDD') START_DATE,
> TO_CHAR(SSRMEET_END_DATE, 'YYYYMMDD') END_DATE,
> SSRMEET_HRS_WEEK PATTERN,
> TO_CHAR(ESEQ>NEXTVAL) SEQ_ORDER,
> '01' FREQUENCY_INTERVAL,
> DECODE(SCBCRSE_CSTA_CODE,'A','1','0') ACTIVE
>FROM SCBCRSE, SSBSECT, SSRMEET
>WHERE SSBSECT_TERM_CODE = '&SEL_TERM_CODE'
> AND SSBSECT_SUBJ_CODE = SCBCRSE_SUBJ_CODE
> AND SSBSECT_CRSE_NUMB = SCBCRSE_CRSE_NUMB
> AND SSRMEET_CRN (+) = SSBSECT_CRN
> AND SSRMEET_TERM_CODE (+) = SSBSECT_TERM_CODE
>ORDER BY SCBCRSE_COLL_CODE,
> RPAD( SSBSECT_SUBJ_CODE, 4 )
> || ' '
> || SSBSECT_CRSE_NUMB,
> SSBSECT_SEQ_NUMB,
> SSBSECT_CRN,
> SSRMEET_CATAGORY
>/
>
>
>Help! Any ideas? Thanks in advance...
>
>Thanks
>Hakim
Received on Fri May 16 2003 - 07:45:20 CDT

Original text of this message

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