Tuesday, 30 October 2012

executing PL/SQL code in TOAD

DECLARE
  P_ST VARCHAR2(200);
  P_PRODUCT VARCHAR2(200);
  P_QUANTITY NUMBER;

BEGIN
  P_ST := 'WA';
  P_PRODUCT := NULL;
  P_QUANTITY := NULL;

  SP_GET_INVENTORY ( P_ST, P_PRODUCT, P_QUANTITY );
  COMMIT;
END;

No comments:

Post a Comment