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,
    I wanna know that how to execute an stored procedure having out parameter in a select statement?
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Store procedure cannot be used in select statement.You can re-write this SP in Function and call this function in Select statement as you need.