Example of Stimulsoft with Oracle Stored Procedure

[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.

[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.

[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.

[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.

[Alex K.]

Hello,

We need some additional time for prepare the sample for you.

Thank you.

[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 4054 times

Add new DataSource

2.PNG (38.78 KiB) Viewed 4054 times

Retrieve Columns

3.PNG (31.82 KiB) Viewed 4054 times

Thank you.

[luis.nakamura]

Hello,

I got retrieve columns, but when run the query show the follow error:

1.jpg (256.66 KiB) Viewed 3767 times

2.jpg (263.54 KiB) Viewed 3767 times

Help me please.

[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.