Calling oracle stored procedure for crystal report
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am working on a database project using oracle 10g database and asp.net. On the page, i have configured crystalreportviewer,crystalreportsource and a SQLDataSource for crystalreportsource. While configuring SQLDatasource it is asking me the input paramter but i do'nt know how can i pass sys_refcursor parameter from design/configuring time. Here is my code of stored procedure: create or replace procedure get_emp(emn in integer,rc out sys_refcursor) is begin open rc for select * from emp where empno=emn; end; / This is working fine in SQLPlus as : VARIABLE cv REFCURSOR EXEC GET_EMP(7788,:CV); print cv; and it is working fine. I am not able to pass the "CV" from code/design time. Please guide and help me. Thanks and Regards Girish Sharma