- View the Bill
- Status
- Debates
- Explanatory Note
- Acts Affected
Error
- JBO-29000: Unexpected exception caught: oracle.jbo.SQLStmtException, msg=JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT B.BILL_ID BILL_ID, B.BILL_NUMBER BILL_NUMBER, B.BILL_NUMBER_SORT BILL_NUMBER_SORT, B.BILL_TITLE BILL_TITLE, B.BILL_STATUS BILL_STATUS, B.THIRD_STAGE_ID THIRD_STAGE_ID, B.MEMBER_ROLE_ID MEMBER_ROLE_ID, B.PARL_REP_ID PARL_REP_ID, B.MEMBER_ID MEMBER_ID, B.BILL_SPONSOR_LASTNAME BILL_SPONSOR_LASTNAME, B.BILL_SPONSOR_SALUTATION BILL_SPONSOR_SALUTATION, B.BILL_SPONSOR_FIRSTNAME BILL_SPONSOR_FIRSTNAME, B.BILL_SPONSOR_MIDDLENAME BILL_SPONSOR_MIDDLENAME, B.BILL_SPONSOR_ROLE BILL_SPONSOR_ROLE, B.LANG_CODE LANG_CODE, B.BILL_SPONSOR_LASTNAME || ', ' || B.BILL_SPONSOR_SALUTATION || B.BILL_SPONSOR_FIRSTNAME || NVL2(B.BILL_SPONSOR_MIDDLENAME, ' ' || B.BILL_SPONSOR_MIDDLENAME, NULL) AS BILL_SPONSOR, SB.PARL_ID PARL_ID, SB.PARL_SESS_ID PARL_SESS_ID FROM LB_BILLS_VW B, LB_SESSION_BILLS_VW SB WHERE (B.BILL_ID = SB.BILL_ID AND SB.STATUS = 1)) QRSLT WHERE (LOWER(lang_code)=:1 AND BILL_ID =:2) ORDER BY PARL_ID DESC, PARL_SESS_ID DESC
- JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT B.BILL_ID BILL_ID, B.BILL_NUMBER BILL_NUMBER, B.BILL_NUMBER_SORT BILL_NUMBER_SORT, B.BILL_TITLE BILL_TITLE, B.BILL_STATUS BILL_STATUS, B.THIRD_STAGE_ID THIRD_STAGE_ID, B.MEMBER_ROLE_ID MEMBER_ROLE_ID, B.PARL_REP_ID PARL_REP_ID, B.MEMBER_ID MEMBER_ID, B.BILL_SPONSOR_LASTNAME BILL_SPONSOR_LASTNAME, B.BILL_SPONSOR_SALUTATION BILL_SPONSOR_SALUTATION, B.BILL_SPONSOR_FIRSTNAME BILL_SPONSOR_FIRSTNAME, B.BILL_SPONSOR_MIDDLENAME BILL_SPONSOR_MIDDLENAME, B.BILL_SPONSOR_ROLE BILL_SPONSOR_ROLE, B.LANG_CODE LANG_CODE, B.BILL_SPONSOR_LASTNAME || ', ' || B.BILL_SPONSOR_SALUTATION || B.BILL_SPONSOR_FIRSTNAME || NVL2(B.BILL_SPONSOR_MIDDLENAME, ' ' || B.BILL_SPONSOR_MIDDLENAME, NULL) AS BILL_SPONSOR, SB.PARL_ID PARL_ID, SB.PARL_SESS_ID PARL_SESS_ID FROM LB_BILLS_VW B, LB_SESSION_BILLS_VW SB WHERE (B.BILL_ID = SB.BILL_ID AND SB.STATUS = 1)) QRSLT WHERE (LOWER(lang_code)=:1 AND BILL_ID =:2) ORDER BY PARL_ID DESC, PARL_SESS_ID DESC
- ORA-01722: invalid number
| Date | Bill Stage | Activity | Committee |
|---|