1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to call a database procedure in a select statements ?

Discussion in 'Oracle Forms and Reports' started by aadityainpccs, Jan 7, 2013.

  1. aadityainpccs

    aadityainpccs Active Member

    Messages:
    52
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    New delhi (INDIA)
    Hello,
    Please anybody tell me that how to execute an stored procedure having out parameter in a select statement?
     
  2. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Hi,

    Can you tell me why you want to execute stored Procedure in a Select Statement.
    Let me know your requirement i can help you out from my end.

    Cheers
    Kamal (kamal.love@gmail.com)
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi aaditya ,

    It is not possible to execute procedure in select statement.

    instead develop function and call procedure from that function.

    for direct call

    in sql :

    Declare one variable

    and try following command from sql prompt.

    exec proc:)var);

    in pl/sql

    call proc(l_var);

    hope this small code will helps
     
    aadityainpccs likes this.
  4. aadityainpccs

    aadityainpccs Active Member

    Messages:
    52
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    New delhi (INDIA)
    Thank You,