Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calling stored procedure from impromptu

Status
Not open for further replies.
tandyaw

tandyaw

Programmer
Feb 9, 2004
17
US
Is it possible to call stored procedure from impromptu?

Thanks,
Lia
 
Sort by date Sort by votes
Yes, open your Impromptu catalog create a new report, and select stored procedure. In the query section type "call and the stored procedure name" example: call sp_orders

Verify the query syntax and click ok

Regards,

Martin
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
291
beegeeblueboy
beegeeblueboy
sconti11
  • Locked
  • Question
Oracle Stored Procedure in Cognos FM????
Replies
0
Views
109
sconti11
sconti11
sruthi2016
  • Locked
  • Question
Help on cognos javascript to pass parameter from one report to another dynamically
Replies
0
Views
115
sruthi2016
sruthi2016
FirstTimeMacroHELP
  • Locked
  • Question
Impromptu Macro Writing
Replies
3
Views
131
FirstTimeMacroHELP
FirstTimeMacroHELP
Rapunzel1
  • Locked
  • Question
Impromptu Macro to save as Excel using a Loop
Replies
1
Views
97
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top