multiple sql queries for a datasource

[Jozef Balga]

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

[HighAley]

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.

[Jozef Balga]

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.

[Alex K.]

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.