Link to home
Start Free TrialLog in
Avatar of Malinda Klein
Malinda Klein

asked on

ORA-00933: SQL command not properly ended in a Select Statement

I'm executing a query inside SSRS and receiving an ORA-00933: SQL command not properly ended.  It's just a SELECT statement but the error appears to be in the Where clause.  Am I specifying the parameter, @PaperBill, incorrectly?

Select ACCTUSAGE_MAIN_V.BILLING_DATE
,ACCTUSAGE_MAIN_V.BILLING_CYCE
,ACCTUSAGE_MAIN_V.BILLING_MONTH
,ACCTUSAGE_MAIN_V.BILLING_YEAR
,ACCTUSAGE_MAIN_V.INVOICE_NUMBER
,ACCTUSAGE_MAIN_V.ACCOUNT_NUMBER
,ACCTUSAGE_MAIN_V.DESCRIPTION
,ACCTUSAGE_MAIN_V.CNT_LAST_NAME
,ACCTUSAGE_MAIN_V.CNT_FIRST_NAME
,ACCTUSAGE_MAIN_V.CNT_ADDR_1
,ACCTUSAGE_MAIN_V.CNT_ADDR_2
,ACCTUSAGE_MAIN_V.CNT_CITY
,ACCTUSAGE_MAIN_V.CNT_STATE
,ACCTUSAGE_MAIN_V.CNT_ZIP
,ACCTUSAGE_MAIN_V.CNT_ZIP_EXTEN
,ACCTUSAGE_MAIN_V.RECEIVE_PAPER_BILL
,ACCTUSAGE_MAIN_V.EMAIL
,ACCTUSAGE_MAIN_V.MIN_INVOICE_NUMBER
,ACCTUSAGE_MAIN_V.MAX_INVOICE_NUMBER
From COMIT_CUSTOM.TAMU_ACCTUSAGE_MAIN_V as ACCTUSAGE_MAIN_V
Where ACCTUSAGE_MAIN_V.RECEIVE_PAPER_BILL = @PaperBill
Order by ACCTUSAGE_MAIN_V.ACCOUNT_NUMBER,ACCTUSAGE_MAIN_V.BILLING_CYCE
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Malinda Klein
Malinda Klein

ASKER

Perfect and fast!