OPENQUERY to call oracle's package

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

OPENQUERY to call oracle's package

Author

Topic

yipchunyu
Yak Posting Veteran

80 Posts

Posted - 2007-12-28 : 21:23:38

Is it possible to do so? any sample code for reference?
Thx

yipchunyu
Yak Posting Veteran

80 Posts

Posted - 2007-12-29 : 22:20:56

I tried the method mentioned here
http://objectsharp.com/cs/blogs/matt/archive/2005/06/13/2221.aspx?CommentPosted=true#commentmessage

However, I can't make it works and it displays error like

Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDAORA'.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ICommandPrepare::Prepare returned 0x80040e14].

Any advice?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources