Thursday, September 26, 2013

Configurator: Check for Model Logic Status using Plsql API

Sometimes its useful to find how many model's logic is not upto date using plsql API. One simple example would be for during republish of the model - if model logic is not upto date at the time of publication processing, publication program will fail and model will not be published. Following block can be handy before running any publication or locally creating configuration for the model using CIO API.

DECLARE
  p_model_id      NUMBER := 1774920;
  x_return_status VARCHAR2(10);
  x_msg_data      VARCHAR2(256);
BEGIN
  CZ_PB_MGR.IS_MODEL_UPTO_DATE( P_MODEL_ID =>p_model_id, X_RETURN_STATUS =>x_return_status, X_MSG_DATA =>x_msg_data);
  dbms_output.put_line('X_RETURN_STATUS = ' || X_RETURN_STATUS);
  dbms_output.put_line('X_MSG_DATA = ' || X_MSG_DATA);
END;

If x_return_status=1 then logic is not upto date, 0 value means logic is upto date.

2 comments:

  1. Can I give this article 10 ... or may be 100 likes :)

    ReplyDelete
  2. These machines can bombard your senses with lights, sounds, or vibrations, all of that are designed to entice you to play both in a on line casino or online. Because of their ability to attract attention, slot machines tend to be the most popular sort of recreation at a on line casino. Before playing in} the sport,s make sure you|ensure you|be certain to} are a responsible player and do not have any addiction issues. Modern slot machines include solid-state electronics could be} set for any desired frequency of payouts. Thus, the home advantage varies widely between about 1 and 50 % depending on circumstances, corresponding to 온라인카지노 authorized necessities and competitors from other casinos.

    ReplyDelete