Home » Other » Client Tools » Passing Multiple Values to the Stored Procedure (Oracle 10g and .NET)
Passing Multiple Values to the Stored Procedure [message #306048] Wed, 12 March 2008 11:51
filgimathew
Messages: 1
Registered: March 2008
Junior Member
The following procedure works fine when I run the procedure directly in SQL Developer. However, when I try to do it through .NET, it doesnot returns anything. It does have the data also. I was testing with the following procedure to see what is going wrong. But still no success. I would appreciate if you could help.

create or replace
PROCEDURE INSP_REMAIN_VALUE_REPORT_SPROC(
strWorkLocKeyList IN VARCHAR2,strInspZoneKeyList IN VARCHAR2,
out_cursor OUT GIMMS_SHARED_PKG.REF_CURSOR)
IS

resultset varchar2(10000):=
' SELECT WORK_LOCATION_CODE FROM GIMMS_WORK_LOCATION where WORK_LOCATION_KEY IN (SELECT tempWZ.value FROM GIMMS_TEMP_NUMBER_LIST tempWZ WHERE tempWZ.VALUE='||'WORK_LOCATION_KEY' ||')';

BEGIN
INSERT INTO GIMMS_TEMP_NUMBER_LIST (COLUMN_NAME, VALUE)
VALUES ('WORK_LOCATION_KEY', TO_NUMBER('17'));


OPEN out_cursor FOR resultset;

END INSP_REMAIN_VALUE_REPORT_SPROC;

[Updated on: Wed, 12 March 2008 11:53]

Report message to a moderator

Previous Topic: ISqlPlus
Next Topic: TOAD 7 and Oracle 9i
Goto Forum:
  


Current Time: Thu Mar 28 06:26:34 CDT 2024