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_D ATE
,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.DESCRIPT ION
,ACCTUSAGE_MAIN_V.CNT_LAST _NAME
,ACCTUSAGE_MAIN_V.CNT_FIRS T_NAME
,ACCTUSAGE_MAIN_V.CNT_ADDR _1
,ACCTUSAGE_MAIN_V.CNT_ADDR _2
,ACCTUSAGE_MAIN_V.CNT_CITY
,ACCTUSAGE_MAIN_V.CNT_STAT E
,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_INVO ICE_NUMBER
,ACCTUSAGE_MAIN_V.MAX_INVO ICE_NUMBER
From COMIT_CUSTOM.TAMU_ACCTUSAG E_MAIN_V as ACCTUSAGE_MAIN_V
Where ACCTUSAGE_MAIN_V.RECEIVE_P APER_BILL = @PaperBill
Order by ACCTUSAGE_MAIN_V.ACCOUNT_N UMBER,ACCT USAGE_MAIN _V.BILLING _CYCE
Select ACCTUSAGE_MAIN_V.BILLING_D
,ACCTUSAGE_MAIN_V.BILLING_
,ACCTUSAGE_MAIN_V.BILLING_
,ACCTUSAGE_MAIN_V.BILLING_
,ACCTUSAGE_MAIN_V.INVOICE_
,ACCTUSAGE_MAIN_V.ACCOUNT_
,ACCTUSAGE_MAIN_V.DESCRIPT
,ACCTUSAGE_MAIN_V.CNT_LAST
,ACCTUSAGE_MAIN_V.CNT_FIRS
,ACCTUSAGE_MAIN_V.CNT_ADDR
,ACCTUSAGE_MAIN_V.CNT_ADDR
,ACCTUSAGE_MAIN_V.CNT_CITY
,ACCTUSAGE_MAIN_V.CNT_STAT
,ACCTUSAGE_MAIN_V.CNT_ZIP
,ACCTUSAGE_MAIN_V.CNT_ZIP_
,ACCTUSAGE_MAIN_V.RECEIVE_
,ACCTUSAGE_MAIN_V.EMAIL
,ACCTUSAGE_MAIN_V.MIN_INVO
,ACCTUSAGE_MAIN_V.MAX_INVO
From COMIT_CUSTOM.TAMU_ACCTUSAG
Where ACCTUSAGE_MAIN_V.RECEIVE_P
Order by ACCTUSAGE_MAIN_V.ACCOUNT_N
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER