Devart Forums

Hello.
1. Please post here the DDL script of your stored procedure (or try to reproduce the problem with the code from my post) because it is not clear from your post which parameter has '$' in its name.

2. As I understood, both your Oracle server and Oracle client are of the 11.2 version, aren't they?

No, my oracle server is Xe Edition 10G and the oracle client is ODAC 11.2 Release 3 (11.2.0.2.1).

Hello.
Any idea regarding this problem?

Thanks.

Hello
- The name and the full version of your IDE;
MS Visual Studio 2008 SP1
- The full version of Devart dbExpress driver for Oracle;
dotConnect for Oracle 6.30 Express - 6.30.160 17-May-11
- How are you using dbExpress drivers with C#?

On the development machine I have:

ODAC 11.2 Release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual Studio
Released December 28, 2010

with tnsnames.ora:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.x)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME=orcl)
)
)

sqlnet.ora :

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, LDAP)
TRACE_LEVEL_CLIENT = OFF
TCP.CONNECT_TIMEOUT=10
SQLNET.SEND_TIMEOUT=5
SQLNET.RECV_TIMEOUT=5
sqlnet.outbound_connect_timeout = 15

connection string:

private static string GetConnectionString()
{
return "Data Source=ORCL;User ID=user;Password=pass;" +
" Pooling = True;Min Pool Size=10;Max Pool Size=20;Connection Lifetime=120;Connection Timeout=60;";

}

sample code:

command = _oracleConnection.CreateCommand();
sql = "GIS_INTERFACE.PK$INTERFACE.F$SET_WAYPOINTS";

command.CommandText = sql;
command.CommandTimeout = 5;
command.CommandType = CommandType.StoredProcedure;

OracleParameter prmOut = new OracleParameter("return", OracleDbType.Number);
prmOut.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(prmOut);

OracleParameter prm00 = new OracleParameter("param_route_name", OracleDbType.VarChar);
prm00.Direction = ParameterDirection.Input;
prm00.Value = name;
command.Parameters.Add(prm00);

OracleParameter prm11 = new OracleParameter("param_login_id", OracleDbType.Number);
prm11.Direction = ParameterDirection.Input;
prm11.Value = configInterfaceData.userId;
command.Parameters.Add(prm11);

command.ExecuteNonQuery();

Hello.
I use dbExpress Drivers.
My oracle server is Xe Edition 10G, the oracle client is ODAC 11.2 Release 3 (11.2.0.2.1).
My connection string is based on tnsnames.ora

Hello.
I have a stored procedure with parameters name like param$first.
In C# client when i call this procedure i obtain an error: ORA-01036: illegal variable name/number.
If i replace the $ character with _ it work ok, but i want to keep the curent form(with $ character) in all my procedures.
This requirement can be solved?

Thank you.

Hello again.
Thanks for the promptness with which you answered me.
Is there any possibility to use arrays with any of your product. Any solution?
I saw an older post about working with array and i wonder if it works in my case: http://www.devart.com/forums/viewtopic. ... ight=array

Thank you.

Hello.
I want to pass an array to a stored procedure.
I have a type like: CREATE TYPE table_number AS TABLE OF number;
and i want to pass this array into procedure p$test(param$array table_number).
How can i do this?


Thank you.

Hello,
The Professional edition has this option?
Thank you.

Hello.
I want to pass an array to a stored procedure.
I have a type like: CREATE TYPE table_number AS TABLE OF number;
and i want to pass this array into procedure p$test(param$array table_number).
How can i do this?


Thank you.