Calling Oracle stored procedure with return parameter from SQL2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Connecting » Calling Oracle stored procedure with return...

Calling Oracle stored procedure with return parameter from SQL2005

Rate Topic

Display Mode

Topic Options

Author

Message

kpokruchin

Posted Friday, January 25, 2008 12:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 08, 2008 7:19 AM
Points: 3, Visits: 29

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?

Post #447331

« Prev Topic | Next Topic »

Permissions