Package call for column data

Rohan Hazarika shared this question 3 years ago
Answered

Hi,

I have a report where the values for one of the columns is a package call to the database by passing of some parameters. Is it possible to create a view/report in yellowfin where a column is the same package call?

If so, how can i do it?

Replies (2)

photo
1

Hi Simon, yes, by package call, i meant a procedure in the DB wherein you pass some parameters and get an output based on the parameters.


I cant seem to find the functionality for stored procedures. Can you tell me how to find it? The only options i get when creating a view are Single Table. Multiple table, and freehand SQL.


Can i create a multiple table view where one of the columns is a stored procedure call?

photo
1

Thanks for that. That helped

Leave a Comment
 
Attach a file