Call PL/SQL Function

Hi, I would like to know how to call a PL/SQL function that is stored in the database, and then if it returns FALSE abort the report. Is a function that validate an user/password and returns a boolean.
Thank you in advance..

Find more posts tagged with

Comments

kclark

So you're wanting to set up a username and password for the reports, correct? In the property binding tab of the data source you can use the expression builder to specify them. You can setup a parameter for the username and password and use these to pass that information to the data source.

kidtorres

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="117539" data-time="1370958558" data-date="11 June 2013 - 06:49 AM">
So you're wanting to set up a username and password for the reports, correct? In the property binding tab of the data source you can use the expression builder to specify them. You can setup a parameter for the username and password and use these to pass that information to the data source. </blockquote>
 
Hi, thank you for your quick response, yes, I am doing that, but what I want to validate is the user/password of the web page. Some users will be able to print some reports, and some not, so I want to validate that.. I want to know how to call the function that validate this, and I dont knowww jejee, i have to do it before Julyyyys so please help meee jaja

Tubal

What problems are you having? 
 
I just run mine from a standard jdbc dataset. 
 
In my dataset query, I just do something like 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT * FROM myFunction(<whatever>)</pre>
 
And it returns the result. 
 
To get this dataset to run, you may have to create a hidden table at the top of your report, and then put the return value into a global variable. Then you could hide the tables on your report you didn't want based on that global variable. 
 
Another way to do it would be to connect to your dataset and get your result in the beforeFactory event (this would be quite a bit more complicated) and then drop everything in your report but a 'Not authorized' message or something if they weren't authorized.