Help me with this Pl/Sql procedure (ORACLE 9i) call from asp.net
-
this is my stored procedure in oracle, am using oracle client, cmd.parameter.add() to RETURN the value of the parameter but its not working. PROCEDURE "SCOTT"."PROCEDURE2" ( "PARAM1" IN NUMBER, "PARAM2" out VARCHAR2) IS varEname VARCHAR2(40):='xxx'; varComm REAL; varSalary CONSTANT NUMBER:=1000; comm_missing EXCEPTION; BEGIN SELECT ENAME, COMM INTO varEname, varComm FROM EMP WHERE EMPNO = param1 ;---7369; IF varComm IS NULL THEN RAISE comm_missing; else dbms_output.put_line('Commision is ' || varcomm ); END IF; param2:=varEname; dbms_output.put_line(param2); EXCEPTION WHEN comm_missing THEN dbms_output.put_line('Commision is NULL'); WHEN no_data_found THEN dbms_output.put_line('Employee Does not Exist'); END "PROCEDURE2"; I need to retrieve the value of param2 inside my Asp.net code. Please help me with Ideas. Salami
-
this is my stored procedure in oracle, am using oracle client, cmd.parameter.add() to RETURN the value of the parameter but its not working. PROCEDURE "SCOTT"."PROCEDURE2" ( "PARAM1" IN NUMBER, "PARAM2" out VARCHAR2) IS varEname VARCHAR2(40):='xxx'; varComm REAL; varSalary CONSTANT NUMBER:=1000; comm_missing EXCEPTION; BEGIN SELECT ENAME, COMM INTO varEname, varComm FROM EMP WHERE EMPNO = param1 ;---7369; IF varComm IS NULL THEN RAISE comm_missing; else dbms_output.put_line('Commision is ' || varcomm ); END IF; param2:=varEname; dbms_output.put_line(param2); EXCEPTION WHEN comm_missing THEN dbms_output.put_line('Commision is NULL'); WHEN no_data_found THEN dbms_output.put_line('Employee Does not Exist'); END "PROCEDURE2"; I need to retrieve the value of param2 inside my Asp.net code. Please help me with Ideas. Salami
check out this link ..hope it will help u... http://aspnet.4guysfromrolla.com/articles/062905-1.aspx regards Ramesh