This content has been marked as final. Show 3 replies
user2626293 wrote:Hi Srinivas,
Thanks for your response, please suggest me as to how we can acheive passing of parameters which can hold multiple values, while making a call to the database procedure from the Oracle Form
Here is an example of procedure...
Hope this helps
CREATE OR REPLACE PROCEDURE P_GET_SAL (P_EMPID NUMBER, P_SAL OUT NUMBER) IS BEGIN SELECT SALARY INTO P_SAL FROM EMPLOYEE WHERE EMPLOYEE_ID=P_EMPID; END; SQL> VAR G_SAL NUMBER; SQL> EXEC P_GET_SAL(100,:G_SAL); PL/SQL procedure successfully completed. SQL> PRINT G_SAL; G_SAL ---------- 2300
If someone's response is helpful or correct, please mark it accordingly.*