Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: How to Execute a procedure returning dynamic Cursor

    I have procedure called user_profile
    It takes a string as input parameter and a cursor as a out put parameter.
    From sql+ how can i execute this procedure.For nornmal procedure syntax is execute <Procedure name> (<parmater>);
    for this what is the syntax.Please helping out in this.


    thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Execute syntax is the same. You just need to declare a variable first:
    Code:
    variable rc refcursor
    execute myproc ('string',:rc)
    You can then open and read the cursor in PL/SQL, or using the SQL Plus PRINT command:
    Code:
    print rc

Posting Permissions

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