SQL Language (MOSC)

MOSC Banner

SP2-0552: Bind variable "B1" not declared. How do I do it?

edited Nov 27, 2011 7:55PM in SQL Language (MOSC) 2 commentsAnswered ✓
Hi,
Im trying to run a SQL in SQLPLUS (11.2.0.2)

SQL> variable sku number;
SQL> exec :sku :=1757933

PL/SQL procedure successfully completed.


SELECT nvl (AVG (ship_carton_wt), 0)
  FROM item_supp_country
 WHERE item IN (
          SELECT sku
            FROM desc_look
           WHERE (CLASS, dept, subclass) = (SELECT CLASS, dept, subclass
                                              FROM desc_look
                                             WHERE sku = :b1 AND ROWNUM = 1)
             AND system_ind = 'F')

SP2-0552: Bind variable "B1" not declared.

How Do I declare B1?

Regards
U

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center