視圖創建失敗：ORA-01027: 不可在資料定義作業中使用連結變數

創建視圖代碼如下：

CREATE OR REPLACE VIEW sales_mal_price_query (NAME,

                                              vendorid,

                                              short,

                                              cost_unitprice,

                                              face,

                                              glue,

                                              release,

                                              thickness,

                                              barcode,

                                              mc_color_text

                                             )

AS

   SELECT   a.NAME, a.vendorid, b.short, g.cost_unitprice,

            a.face || c.mc_face_text AS face,

            a.glue || d.mc_glue_text AS glue,

            a.release || e.mc_release_text AS release, a.thickness, a.barcode,

            f.mc_color_text

       FROM material.material a,

            sales.vendor b,

            material.mc_face c,

            material.mc_glue d,

            material.mc_release e,

            material.mc_color f,

            (SELECT   MAX (x.cost_unitprice) cost_unitprice, y.barcode

                 FROM material.all_material_price_range x,

                      material.material y

                WHERE x.barcode(+) = y.barcode

             GROUP BY y.barcode) g

      WHERE DECODE (:p_vendorid, NULL, '1', a.vendorid) =

                                   DECODE (:p_vendorid,

                                           NULL, '1',

                                           :p_vendorid

                                          )

        AND DECODE (:p_face, NULL, '1', a.face) =

                                           DECODE (:p_face,

                                                   NULL, '1',

                                                   :p_face

                                                  )

        AND DECODE (:p_glue, NULL, '1', a.glue) =

                                           DECODE (:p_glue,

                                                   NULL, '1',

                                                   :p_glue

                                                  )

        AND DECODE (:p_release, NULL, '1', a.release) =

                                     DECODE (:p_release,

                                             NULL, '1',

                                             :p_release

                                            )

        AND DECODE (:p_name, NULL, '1', a.NAME) LIKE

                              '%' || DECODE (:p_name, NULL, '1', :p_name)

                              || '%'

        AND a.vendorid = b.vendorid

        AND a.face = c.mc_face_code

        AND a.glue = d.mc_glue_code

        AND a.release = e.mc_release_code

        AND a.color1 || a.color2 = f.color1 || f.color2

        AND a.barcode = g.barcode

   ORDER BY barcode

報錯：ORA-01027: 不可在資料定義作業中使用連結變數
ORA-01027 bind variables not allowed for data definition operations

Cause: An attempt was made to use a bind variable in a SQL data definition operation.

Action: Such bind variables are not allowed.

不知該怎樣處理？？求助！