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
 SQL Server Development (2000)
 calling external methods

Author  Topic 

muthuprasad
Starting Member

2 Posts

Posted - 2006-03-28 : 00:24:58
hai
I need need to call external methods from tigger as oracle can call external java function is it possible if yes how? plz tell me thanks in advance

prasad

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-03-28 : 00:50:18
you mean like an exe file? you can invoke via xp_cmdshell, but this will be too intensive, imagine if you have 10 records affected, and the file will be invoked 10x...

anyways, it's your requirement...you can however post why you need this to occur and we might propose some alternative solutions

--------------------
keeping it simple...
Go to Top of Page

muthuprasad
Starting Member

2 Posts

Posted - 2006-03-29 : 02:32:40
Thanks for your reply jen
i don't need to call a exe file i need to call a function in a program it may be either a vb or java code is it possible.

prasad
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-29 : 03:08:55
What does the function do?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -