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.
| Author |
Topic |
|
vl
Starting Member
14 Posts |
 Posted - 2007-06-19 : 16:22:20
|
| How to call a oralce stored procedure (Package),function from oracle link server?I did the following:select link_server_name..schema_name.MyFunc('tom')I got the following error message:The object name contains more than the maximum number of prefixes. The maximum is 2. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-19 : 16:40:41
|
| have you tried using OPENQUERY instead?-ec |
 |
|
|
|
|
|
call oracle function through oracle link server