Devart Forums

Hi,

I'm trying to find out how to retrieve the result of the DBMS_OUTPUT.GET_LINES() procedure in my C# code. I managed to retrieve a single line using the DBMS_OUTPUT.GET_LINE() procedure.

The problem I have is, that the first parameter of the GET_LINES() procedure is a CHARARR Type and I don't know which OracleDbType I should use.

If you are using .NET Connect from Oracle there you can do something like this (using an associative array parameter):

// create an associative array parameter
OracleParameter p_5 = new OracleParameter();
p_5.OracleDbType = OracleDbType.Varchar2;
p_5.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
p_5.Direction = ParameterDirection.Output;
p_5.Value = null;
p_5.Size = 2;
p_5.ArrayBindSize = new int[2] { 32, 32 };

Is there a similar way in the dotConnect for Oracle component ?

Thanks for your help,
Mirko

Hi,

the Package DBMS_ALERT Package is installed and granted to the user, who starts the alerter. We've tested it with our old delphi Clients (they are using the doa components to connect to oracle) and this works perfectly. (same database, same oracle user)

So this can't be the problem. Does your component needs any extra "rights", to use this feature ? (e.g. execute with GRANT OPTION ? )

Best regards,
Mirko

Yes It was no problem to install the new version. But nevertheless the problems with the open byte arrays still exists in 4.60. My question was, if the original problem (open byte arrays) is solved....

cheers

mirko

Hello,

any news about this ? Because we do have the same problem (version 4.60)...

cheers
mirko