Calling Oracle stored procedure with return parameter from SQL2005

• kpokruchin

  SSC Enthusiast

  Points: 151

  More actions

  January 25, 2008 at 12:54 am

  #93884

  Please help me!

  I`ve got an Oracle stored procedure with several input params and one return parameter(cursor)

  I can't execute it from SQL2005

  Ex: select * from openquery (ORA_SERV, 'call {ORA_PROC({''p1'', ''p2'', ''p3'', p4, curs OUTput })}')

  What`s wrong? And how can i get data from returned cursor?