Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    21

    Unhappy Unanswered: Need to create an SP

    Hi all,
    I am a novice to oracle.I need to create a SP where the query is dynamic.ie the where condition vary.

    Thanks in advance.

  2. #2
    Join Date
    Mar 2004
    Posts
    370
    A very simple case:
    Code:
    create or replace procedure test (p_inp number
                                                           ,p_result out sys_refcursor)
    as
    begin
     open p_result for
     select emp_name from employee where emp_id = p_inp;
    end;
    /
    See http://tahiti.oracle.com/ and search "pl/sql developer guide".
    -Good luck!

  3. #3
    Join Date
    Oct 2005
    Posts
    21
    Thank You for the solution.

Posting Permissions

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