| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
