This discussion is archived
0 Replies Latest reply: Aug 13, 2008 3:49 AM by 654475 RSS

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

654475 Newbie
Currently Being Moderated
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 :(