Home » SQL & PL/SQL » SQL & PL/SQL » help
help [message #37473] Mon, 11 February 2002 05:30 Go to next message
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&regs
sam
Re: help [message #37474 is a reply to message #37473] Mon, 11 February 2002 06:09 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: How to execute a procedure
Next Topic: is this possible
Goto Forum:
  


Current Time: Sun Sep 27 19:17:53 CDT 2020