on 06-13-2007 5:23 AM
I am having problem with stored procedure through business view. I have an oracle stored procedure sp1 ( p1 in out ref_cursor, p2 in varchar2), I don't have any problem if I use it in crystal report directly.
But I use it through business view, I got issue. Here are what I did
1. create data connection in business view manager
2. create data foundation pointing to the stored procedure sp1
3. create business elements
4. create business view sp_view
so far so good,
5. now in crystal report, I make a new connection to the repository and point to sp_view, select fields I am interested, then I run the report, parameter p2 pop up, that's good, after that I got an error message "failed to retrieve data from database". I checked sql that the report use its call sp1(p2), seems crystal report doesn't recognized the output parameter?
any suggestions? I am on crystal report XI service pack 1
Thanks in advance.
Please re-post if this is still an issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.