Page 1 of 1
Example of Stimulsoft with Oracle Stored Procedure
Posted: Wed Aug 22, 2012 2:32 pm
by Batuta
Would you be able to provide an example report with the data being populated from an Oracle Stored Procedure?
It would also be good if for example, there is some parameters being passed to a query.
Thanks.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Thu Aug 23, 2012 6:35 am
by Alex K.
Hello,
Could you clarify what is the issue when creating a data source as Oracle Stored Procedure?
Also please clarify which connection do you use?
Thank you.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Thu Aug 23, 2012 2:09 pm
by Batuta
Hi Aleksey,
I am using an Oracle Connection which was provided through a dll that was compiled using the source provided in the downloads section of your site for Oracle connections.
I am looking for an example where you use an Oracle Stored Procedure in a report. Would you be able to provide a good example?
Something that returns multiple rows from a table, with parameters being passed on the procedure to filter out / or sort the result set.
Thanks.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Thu Aug 23, 2012 3:33 pm
by Batuta
Just for an example, I have the following stored proc:
Code: Select all
PROCEDURE GetJobHistory
(
paramPersonnelID IN NUMBER,
CursorJobHistory OUT T_CURSOR
)
AS
BEGIN
OPEN CursorJobHistory FOR
SELECT PERSONNELID,
TO_CHAR(JOB_START_DATE, 'Mon DD/YYYY') AS JOB_START_DATE,
TO_CHAR(JOB_END_DATE, 'Mon DD/YYYY') AS JOB_END_DATE,
JOB_CLASS,
JOB_DESCRIPTION,
QUALIFICATION,
UNION_CODE
FROM JOB_HISTORIES_VW
WHERE PERID = pPerID
ORDER BY JOB_START_DATE ASC;
END GetJobHistory;
That stored procedure is in a package.
I need some guidance on how I would be able to define it on the New Data Source screen.
Thanks.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Fri Aug 24, 2012 1:45 pm
by Alex K.
Hello,
We need some additional time for prepare the sample for you.
Thank you.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Tue Aug 28, 2012 10:49 am
by Alex K.
Hello,
The step by step sample for Oracle ODP.NET Connection:
Stored procedure with RefCursor parameter in Oracle Database
- 1.PNG (31.65 KiB) Viewed 4055 times
Add new DataSource
- 2.PNG (38.78 KiB) Viewed 4055 times
Retrieve Columns
- 3.PNG (31.82 KiB) Viewed 4055 times
Thank you.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Thu Nov 27, 2014 3:35 pm
by luis.nakamura
Hello,
I got retrieve columns, but when run the query show the follow error:
- 1.jpg (256.66 KiB) Viewed 3768 times
- 2.jpg (263.54 KiB) Viewed 3768 times
Help me please.
Re: Example of Stimulsoft with Oracle Stored Procedure
Posted: Fri Nov 28, 2014 12:13 pm
by Alex K.
Hello,
We couldn't reproduce this bug.
Please try to read a more information about this error on the Orracle information center.
https://search.oracle.com/search/search ... =ORA-06550
Thank you.