Creating reports and dashboards | Stimulsoft community forum

Posted: **Mon Mar 25, 2013 6:36 am**

Hello!

I would like to ask: it is possible to invoke multiple sql queries for the datasource?
I mean something like this in the query editor:

Code: Select all

ALTER SESSION SET nls_sort='slovak_ai';
ALTER SESSION SET nls_comp = 'linguistic';
select * from table(reports_pkg.rp_ar_05_body('SK', to_date('01/03/2013','dd/mm/yyyy'), to_date('15/03/2013','dd/mm/yyyy'), to_date('01/03/2013','dd/mm/yyyy'), to_date('15/03/2013','dd/mm/yyyy'), null, null, null, null));

I use an Oracle 11.2.0 database. Thank you for the answer.

Jozef

Posted: **Mon Mar 25, 2013 8:10 am**

Hello.

We can not check if it work now. But there is no such problems from our costumers.
Let us know if you will have any problem with such queries.

Thank you.

Posted: **Mon Mar 25, 2013 9:17 am**

Yes, I have probleM executing the following simple query

Code: Select all

ALTER SESSION SET nls_sort='slovak_ai';
ALTER SESSION SET nls_comp = 'linguistic';
select * from dual;

It returns the following error:
----------------------------
[Customer Explanation]

----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework: v4.0.30319
Version: Version: 2013.1.1512 from 11 March 2013
MachineName: WKS-BALGA
OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
UserName: balga

----------------------------
[Exception Info]
Message: ORA-00911: invalid character

Source: Oracle Data Provider for .NET

StackTrace:
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Stimulsoft.Report.Dictionary.StiOracleODPAdapterService.ConnectDataSourceToData(StiDictionary dictionary, StiDataSource dataSource, Boolean loadData)
at Stimulsoft.Report.Dictionary.StiDataSource.Connect(StiDataCollection datas, Boolean loadData)
at Stimulsoft.Report.Dictionary.Design.StiDataStoreSourceEditForm.tbRunScript_Click(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 2.0.0.0
Stimulsoft.Base, Version = 2013.1.1512.0
Stimulsoft.Report, Version = 2013.1.1512.0
Stimulsoft.Report.Design, Version = 2013.1.1512.0
System.Windows.Forms, Version = 2.0.0.0

Thank you for your time.

Posted: **Tue Mar 26, 2013 6:57 am**

Hello,

Unfortunately, we are not familiar with the Oracle. We have not even made the request work in a simple project in the Studio without using our product. Can you please send us a sample code which working with your sent query without the error in Studio.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

multiple sql queries for a datasource

multiple sql queries for a datasource

Re: multiple sql queries for a datasource

Re: multiple sql queries for a datasource

Re: multiple sql queries for a datasource