Package call for column data

Rohan Hazarika shared this question 3 months 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?

Comments (5)

photo
1

Hi Rohan,


Thanks for your message.


Big apologies, however, I'm unsure what you mean by a 'Package Call'. I found this article with regard to Oracle, where it sounds like a package is a collection of functions and procedures. Functionally, it seems that this is similar functionality to stored procedures/ functions/ views etc. where you should just be able to create a View, using the Yellowfin View Builder (after making a valid Database Connection) and reference the result of this Package and create a Yellowfin Report.


Let me know if I've understood this correctly.


Kind regards,

Simon

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

Hi Rohan,


Thanks for clarifying that.


One thing to double-check would be the Role Functions of the Role that you are using. If you go to Admin Console > (Role) > Data Sources & Views there is an option for Stored Procedures. Make sure this is checked, and then try again.


/f25fa0c3818bd234ec17bb6eff94bd16


There is a chance that this still won't work as it looks like packages might be closer to a group of Stored Procedures, in which case I will need to change this to an Idea to be considered as an Enhancement Request for the Developers.


Let me know how you go!


Kind regards,

Simon

photo
1

Thanks for that. That helped

photo
1

Hi Rohan,


Not a problem, I'm glad I could help.


Let me know if you have any further questions, otherwise, I will go ahead and mark this as answered for the moment.


Kind regards,

Simon