help [message #37473] |
Mon, 11 February 2002 05:30 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
Hi,
i have stored proc through which iam executing 2 other storedprocs, one local and one remote.
when ever i execute only local stored proc is getting executed and iam able to see the output, not the remote one.
i have link setup, everything seems fine. but iam not getting the remote proc output
any suggestions
thanx®s
sam
|
|
|
Re: help [message #37474 is a reply to message #37473] |
Mon, 11 February 2002 06:09 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
hi,
are u using dbms_output.put_line to output. what u mean by can not see output.what type of output u want to see.what type of output u can see during execution of loac procedure.can u explain little bit more.
cheers
pratap
|
|
|
Re: help [message #37476 is a reply to message #37474] |
Mon, 11 February 2002 06:53 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
hi,
make sure you have dbms_output.put_line in remote procedure.if it is there and still not showing output, then create a temp. table and just before the end of remote procedure write
insert into temp_table('sucessfully ran',sysdate)
other wise u can maintain an error table in the same way.
|
|
|
Re: help [message #37478 is a reply to message #37474] |
Mon, 11 February 2002 09:50 |
ron
Messages: 50 Registered: July 1999
|
Member |
|
|
Try checking the previleges on the remote.
the action u want to perform can test alone and
see. if it works out side proc, it should work inside proc.
|
|
|