DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to load many parameter input into PL/SQL Procedure ?

  1. #1
    Join Date
    Jan 2003
    Location
    Thailand
    Posts
    5

    How to load many parameter input into PL/SQL Procedure ?

    Pls kindly help suggest how to load many parameter input for update the table. I have two parameter to load it for each update statement.

    update employee
    set emp_name = &a
    ,emp_salary = &b;

    Thank you very much.
    Plammy

  2. #2
    Join Date
    Jul 2002
    Location
    Slovenia
    Posts
    42
    How to load many parameter input into PL/SQL Procedure ?
    Pls kindly help suggest how to load many parameter input for update the table. I have two parameter to load it for each update statement.

    update employee
    set emp_name = &a
    ,emp_salary = &b;

    CREATE OR REPLACE PROCEDURE upd_emp_proc(param_emp_name IN VARCHAR2, param_emp_salary IN NUMBER) IS
    BEGIN
    UPDATE employee
    SET emp_name = param_emp_name,
    emp_salary = param_emp_salary
    WHERE EMPLOYEE_ID = whatever(parameter?);
    END upd_emp_proc;
    Andrej

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width