Database to invalid id background error ORA - 00904: "T". "BD_SID" : identifier is invalid

CodePudding user response:

The select cciid sid, product_name, cciid del_count, belong_area belongArea
The from (
Select A. *, ROWNUM numx from (
Select Max (product_name) product_name, Max (cciid cciid), sum (delivery_num) del_count, belong_area from (
The select cci product_name, cci. Sid cciid, ism. Delivery_num, bd. Ordered,
(SELECT b.d istrict_name FROM base_district b where b.d istrict_level=? START WITH b.s id=bd. Sid CONNECT BY the PRIOR p. _sid=b.s id) belong_area
The from ios_stock_manage ism
Left the join ci_chemicals_index cci on cci. Sid=ism. Cciid
Left the join corp_base_info t on t.s id=ism. Corp_id
Left the join base_district bd on t.b d_sid=bd. Sid
Where cci. Sid=? And bd. District_code like? )
A group by belong_area, ordered the order by ordered)
WHERE 1=1 and del_count & lt;> 0)
WHERE 1=1

CodePudding user response:

O master SQL see something wrong! Separate open check is in the middle of the first submitted to the invalid identification error!

CodePudding user response:

Is within the stored procedure, function? Or separate?
The inside of the code "?" Is a parameter or variable?

Such as line 11: the where cci. Sid=? And bd. District_code like? )

CodePudding user response:

In a BD_SID within the code, the content of the error, did you see corp_base_info table BD_SID field;

CodePudding user response:

Left associated directly associated with the left table is not even, left the associated tables are only associated with the main table
If take base_district links corp_base_info made a result set first, and then the main table