Skip to Content
Former Member
Jun 13, 2007 at 04:23 AM

stored procedure through business view


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.