Oracle Stored Procedure Problem

Mike_Fitzsimmons_(nara01admin_-_(deleted))

Hello,I am attempting to call an Oracle 9.2 stored proceduer (note: I cannot call a function as I must use the existing stored procedure). The stored procedure has the following prarameters:PROCEDURE my_proc (P_NAME IN OUT VARCHAR2 ,P_NUM IN OUT NUMBER ,P_DIST IN OUT VARCHAR2 ,P_MODE IN VARCHAR2 ,P_GRP IN VARCHAR2 ,P_DIV IN VARCHAR2 := NULL ,P_CVD IN NUMBER := NULL ,P_SPEC IN VARCHAR2 := NULL ); I can successfully call the procedure fine in SQL+ with the following...SET SERVEROUTPUT ONDECLAREP_NAME VARCHAR2(4000);P_NUM NUMBER;P_DIST VARCHAR2(4000);BEGIN P_NAME := NULL; P_NUM := NULL; P_DIST := NULL; populate_pkg.update_prc(P_NAME,P_NUM,P_DIST,'001','XX',NULL,NULL,NULL);dbms_output.put_line(SubStr('P_NAME = '||P_NAME,1,255));END;Does anyone know how I can call this stored procedure in Livelink, gettting the three output parameter values? Any help would be GREATLY appreciated!!!Thanks.

eLink User

Message from Alex Kowalenko via eLinkHi John,Hope you are doing well these days.Try this out: Dynamic result = CAPI.Exec( prgCtx.fDBConnect.fConnection, \ 'select my_proc( :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8 ) fromdual', \ p1, p2, p3, p4, p5, p6, p7, p8 )where pi are your input parameters. If successful, the result RecArraywill contain what is returned by the procedure.-alex------Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Friday, September 24, 2004 1:43 PMTo: eLink RecipientSubject: Oracle Stored Procedure ProblemOracle Stored Procedure ProblemPosted by Evans, John on 09/24/2004 01:41 PMHello,I am attempting to call an Oracle 9.2 stored proceduer (note: I cannotcall a function as I must use the existing stored procedure). The storedprocedure has the following prarameters:PROCEDURE my_proc (P_NAME IN OUT VARCHAR2 ,P_NUM IN OUT NUMBER ,P_DISTIN OUT VARCHAR2 ,P_MODE IN VARCHAR2 ,P_GRP IN VARCHAR2 ,P_DIV INVARCHAR2 := NULL ,P_CVD IN NUMBER := NULL ,P_SPEC IN VARCHAR2 := NULL); I can successfully call the procedure fine in SQL+ with the following...SET SERVEROUTPUT ONDECLAREP_NAME VARCHAR2(4000);P_NUM NUMBER;P_DIST VARCHAR2(4000);BEGIN P_NAME := NULL; P_NUM := NULL; P_DIST := NULL; populate_pkg.update_prc(P_NAME,P_NUM,P_DIST,'001','XX',NULL,NULL,NULL);dbms_output.put_line(SubStr('P_NAME = '||P_NAME,1,255));END;Does anyone know how I can call this stored procedure in Livelink,gettting the three output parameter values? Any help would be GREATLYappreciated!!!Thanks.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe