Re: ORA-00933 SQL command not properly ended

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

For these types of questions it is most helpful if you include the text of
the error message you receive.  This is what I see off the top of my head.

Insert into PS_CLASS_SBFEE_TBL
( SELECT
$SetID,                 <====Bind variable in must be in [brackets]
A.CRSE_ID,
A.CRSE_OFFER_NBR,
A.STRM,
A.SESSION_CODE,
A.CLASS_SECTION,
A.COMPONENT,
'MND',
403400000000,
' ',
' ',
'ADMIN',
0.00,                  <==If this is a varchar fields then must
0.00,                  <==be in 'quotes' if not 0 is suficient.
0.00,                  <==this shouldn't cause an error however
0.00,                  <==if it is in fact an number field, unless the
0.00,                  <==perhaps the number precision is causing an error.
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')    <====Odd number of brackets one
)                         <====of theses needs a mate or removal

-Alan




                    "Brickl,
                    Maria"                To:     SQR-USERS@list.iex.net
                    <mbrickl@UWC.E        cc:
                    DU>                   Subject:     ORA-00933 SQL command 
not properly ended
                    Sent by:
                    "Discussion of
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    05/22/2002
                    08:37 AM
                    Please respond
                    to sqr-users






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
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*