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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

call stored procedure in impromptu

Status
Not open for further replies.
Sharma999

Sharma999

Technical User
Jan 8, 2004
12
US
Hi,
I am using oracle stored procedure as my data source.
In that procedure 1 input and 1 output parameter is there.
So how can i call that procedure in stored procedure
query box in impormptu.
Thank you
Sharma
 
Sort by date Sort by votes
Hi,

You can use the Stored Procedure template to create an Impromptu report provided the output parameter of the stored procedure is of ref cursor type....

Hope this helps...

Regards,
 
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
157
beegeeblueboy
beegeeblueboy
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
147
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
121
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
127
wwconslt
wwconslt
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
120
Goutham3835
Goutham3835

Part and Inventory Search

Sponsor

Back
Top