Oracle error
From: Mohammad <mhakimjavadi_at_hotmail.com>
Date: 15 May 2003 12:46:53 -0700
Message-ID: <cc59b627.0305151146.3017623a_at_posting.google.com>
/
Date: 15 May 2003 12:46:53 -0700
Message-ID: <cc59b627.0305151146.3017623a_at_posting.google.com>
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 Thu May 15 2003 - 21:46:53 CEST