0 Replies Latest reply: Aug 13, 2008 5:49 AM by 654475 RSS

    is there any chance to make stored procedure without giving any input value

    654475
      we are converting a whole database from sql to oracle
      there are so many stored procedures and we have to make it work
      i used oracle sql developer to convert the database
      there are no problem at table and datas
      but at stored procedures it is pain as hell


      our stored procedure start like this
      create or replace
      PROCEDURE Smart_Procedure_Trmnl_LIST
      (
      v_pTerminal_Id CHAR DEFAULT NULL ,
      v_pMerchantId CHAR DEFAULT NULL ,
      v_pInstitutionId IN NUMBER DEFAULT NULL ,
      v_pFileFlag IN NUMBER DEFAULT NULL ,
      v_pZoneCode IN CHAR DEFAULT NULL ,
      v_pLine IN VARCHAR2 DEFAULT NULL ,
      v_pSerialNumber IN VARCHAR2 DEFAULT NULL ,
      v_pVehiclePlate IN VARCHAR2 DEFAULT NULL ,
      v_pTypeCode IN CHAR DEFAULT NULL ,
      v_pOptionalField IN VARCHAR2 DEFAULT NULL ,
      cv_1 IN OUT SYS_REFCURSOR,
      cv_2 IN OUT SYS_REFCURSOR,
      cv_3 IN OUT SYS_REFCURSOR,
      cv_4 IN OUT SYS_REFCURSOR,
      cv_5 IN OUT SYS_REFCURSOR,
      cv_6 IN OUT SYS_REFCURSOR,
      cv_7 IN OUT SYS_REFCURSOR,
      cv_8 IN OUT SYS_REFCURSOR
      )

      what i want is i dont want to give any input for these variables
      v_pTerminal_Id CHAR DEFAULT NULL ,
      v_pMerchantId CHAR DEFAULT NULL ,
      v_pInstitutionId IN NUMBER DEFAULT NULL ,
      v_pFileFlag IN NUMBER DEFAULT NULL ,
      v_pZoneCode IN CHAR DEFAULT NULL ,
      v_pLine IN VARCHAR2 DEFAULT NULL ,
      v_pSerialNumber IN VARCHAR2 DEFAULT NULL ,
      v_pVehiclePlate IN VARCHAR2 DEFAULT NULL ,
      v_pTypeCode IN CHAR DEFAULT NULL ,
      v_pOptionalField IN VARCHAR2 DEFAULT NULL ,

      but stored procedure doesnt work without giving any value

      and if i give anything it wont be null and whole stored procedure get screwed :(