moeff Posted January 21, 2007 Share Posted January 21, 2007 Hi, In my oracle-DB environment I allways have to execute a certain PL/SQL code in front of it. This PL/SQL statement does all the proper settings for accessing the data correctly. So e.g. all my statements (when I run them in SQLPLUS look like this: begin sde.version_util.set_current_version('SDE.DEFAULT');end;/ select name, last_name, date_of_birth from view_friends; Do you have any idea, how to get to handle this kind of commands in the ireport environment? Thanks for your ideas Stephan Link to comment Share on other sites More sharing options...
jmurray Posted January 21, 2007 Share Posted January 21, 2007 You can't call a stored procedure in that fashion, but you can call a stored function that executes a stored procedure. Using a function means that you can even return a result code and take appropriate action if the procedure fails. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now