1

I was defining a string output parameter in the RETURNING clause of an INSERT statement using ODP.NET. I was not able to get any value returned. It worked fine for other DbTypes.

1 Answer 1

2

I tracked down the problem as being the following. Oracle seems to require the size parameter to be set for output string parameters to indicate the maximum size of the string to be retrieve. The default (0) causes the output value to be an empty string.

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.