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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2008-04-02 : 10:29:54
|
| I am just starting to learn about stored procs and how great they can make my world. I have been able to create a pro that does some data checking and inserts based on the results but what I have not been able to figure out is how would I pass a message from the proc to my Perl script that calls it? If anyone could point me in the right direction on what commands I should be looking into I would appreciate it.-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-02 : 10:38:15
|
You need to declare an output parameter in SP and then set message text in this parameter.Create Proc SomeSp(@p1 int,@p2 int,@out varchar(200))as-- some logicSet @out = 'Some Message here'GO I don't know how the SP is called and output parameter is accessed from Perl script though.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Returning values from SP to Perl script.