Home » Developer & Programmer » Reports & Discoverer » nested stored procedures - Please help!
nested stored procedures - Please help! [message #88198] Tue, 30 April 2002 19:25 Go to next message
Renu
Messages: 7
Registered: February 2002
Junior Member
I have written a stored procedure ( GetFileTitle) that is going to go through a record, get the names of the parties, append them and send the result out under the heading 'file title'

I also have another stored procedure(GetRecDetails) that runs a select statement, getting info from 2 tables on the database. This returns info like Applic num, sequence etc.

I have tried to add -
exec GetFileTitle
- at the end of the select statement, but it comes up with an error

I have also tried to add -
union
exec GetFielTitle
- at the end of the bit of code, but that comes up with an error too.

Please help!!
Re: nested stored procedures - Please help! [message #88368 is a reply to message #88198] Fri, 19 July 2002 08:15 Go to previous message
shel
Messages: 3
Registered: July 2002
Junior Member
You don't have to put the keyword "exec" when you are calling the SP. Just call the SP by its name..and you should be all set to go..
Good Luck
Previous Topic: Please help
Next Topic: Need urgent help
Goto Forum:
  


Current Time: Fri Mar 29 05:25:09 CDT 2024