Oracle dynamic parameters error

Question

I got the function that returns me a varchar2.

I'm using dapper and I got a problem while executing this query.

OracleDynamicParameters DictionaryParams = new OracleDynamicParameters();

DictionaryParams.Add(name: "id", value: id,direction: ParameterDirection.Input);
DictionaryParams.Add(name: "Return_Value",oracleDbType: OracleDbType.Varchar2,direction: ParameterDirection.ReturnValue);

con.Execute("function_name", DictionaryParams, commandType: CommandType.StoredProcedure);

 string a;

 a = DictionaryParams.Get<string>("Return_Value");

And I got an Oracle error:

ORA-06502: PL/SQL: error number or value :character string buffer too small

I tried to give a size to a returning value but this didn't work, and I also tried to figure out but everything didn't worked.

Can someone take a look at this?

Could the error be in the procedure call itself? If you call the procedure directly from sqlplus, does it work? — OldProgrammer
– OldProgrammer, Commented Sep 9, 2015 at 14:53

Renato Saito · Accepted Answer · 2015-12-16 16:59:00Z

2

You need to specify the max size of the varchar2.

Example:

parameters.Add("P_OUTPUT", dbType: OracleDbType.Varchar2, direction: ParameterDirection.Output, size: 1000);

answered Dec 16, 2015 at 16:59

Renato Saito

4115 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Emanuele Greco · Accepted Answer · 2015-09-09 15:40:00Z

0

I suppose the problem originates from using Char which is a fixed length string.
Somewhere in your PL-SQL code you try to put a Char or varchar2 string of length N into a char of lengh M where M > N

answered Sep 9, 2015 at 15:40

Emanuele Greco

12.8k7 gold badges55 silver badges72 bronze badges

Collectives™ on Stack Overflow

Oracle dynamic parameters error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related