0 Replies Latest reply: Dec 11, 2008 6:12 AM by 675112 RSS

    Form Personalization : Trying to run a procedure

    675112
      Hi,
      Iam trying to run a procerure through FP, but an error is firing when passing a parameter.
      actually that parameter is a combination of varchar,date.
      I want only one value form that parameter.
      How to fetch a single parameter from a multi parameter field.

      'begin REVENUE_UNRELEASE('||${item.set_requests.parameters.value}||'); end'

      This is the code iam using in personalization.

      My procedure is :

      CREATE OR REPLACE PROCEDURE REVENUE_UNRELEASE(V_PARAMETERS IN VARCHAR2) IS

      V_PROJECT_NUMBER VARCHAR(10);
      BEGIN

      BEGIN
      SELECT SUBSTR(V_PARAMETERS, 1, 7) INTO V_PROJECT_NUMBER FROM DUAL;
      EXCEPTION
      WHEN OTHERS THEN
      NULL;
      END;
      END TCS_PA_REVENUE_UNRELEASE;

      Kindly help me in resolving this.