Package call for column data
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?
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
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?
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.
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
Thanks for that. That helped
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
Comments have been locked on this page!