Re: ORA-00933 SQL command not properly ended

["Brickl, Maria" <mbrickl@UWC.EDU>]

Thanks! That was it - there were too many ')'.


-----Original Message-----
From: Wendel, Robbi [mailto:rwendel@NESPOWER.COM]
Sent: Wednesday, May 22, 2002 9:48 AM
To: SQR-USERS@list.iex.net
Subject: Re: ORA-00933 SQL command not properly ended


Looks like too many  ')'

-----Original Message-----
From: Brickl, Maria [mailto:mbrickl@UWC.EDU]
Sent: Wednesday, May 22, 2002 9:37 AM
To: SQR-USERS@list.iex.net
Subject: ORA-00933 SQL command not properly ended


I have looked and looked at this code and I can't see where it could be
possibly wrong. Can anyone else see the problem?

!******************************************
!* Insert-MND-Sub-Fee
!******************************************
Begin-Procedure Insert-MND-Sub-Fee

display 'Insert-MND-Sub-Fee procedure starting'

Begin-SQL ON-ERROR=SQL-Error-INSERT

Insert into PS_CLASS_SBFEE_TBL
( SELECT
$SetID,
A.CRSE_ID,
A.CRSE_OFFER_NBR,
A.STRM,
A.SESSION_CODE,
A.CLASS_SECTION,
A.COMPONENT,
'MND',
403400000000,
' ',
' ',
'ADMIN',
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
'USD',
'ONLADM',
'STANDARD',
'LI_ADMWAV',
'N'
>From PS_CLASS_TBL A
WHERE (A.CLASS_SECTION LIKE '%Q'
OR    A.CLASS_SECTION LIKE 'Q%')
AND   A.STRM = '1031')
)

End-SQL

display 'Insert-MND-Sub-Fee procedure ending'


End-Procedure Insert-MND-Class-Sub-Fees

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Maria K Brickl
mbrickl@uwc.edu <mailto:mbrickl@uwc.edu>
Information Systems Programmer/Analyst
University of Wisconsin Colleges
780 Regent St, PO Box 8680, Madison, WI  53708-8680
Phone: 608.265.2677 / Fax: 608.265.5770
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*