Need help calling Oracle stored proc in a packadge from .NET C# client

[cwendell]

Hello;
I am a DBA working on a new project with a developer using .NET and C#. I have created a Package (RECORDER_API) with a very simple Procedure in it (add_row). This package is owned by RECORD_OWNER. A synonym has been created for an account RECORD_USER. Execute on RECORDER_API has been granted a role (RECORDING) and this role has been granted to RECORD_USER.

The Procedure add_row has a number of IN parameters but I am having problems with one of them. It is a v_MESSAGE VARCHAR2 ( I have also use %TYPE). When the .NET C# program runs it tries to insert 22 characters and fails saying the max is 18 (The error is an Oracle error). The column is VARCHAR2(256 bytes).

Another problem I am having is the developer needs to be able to see the procedures in the RECORD_API package inside .NET. All he can see is synonym.

The last problem is that at run time he needs to be able to declare a size to hold the VARCHAR2 value but his tools show a length of 0 (zero).

Any hep would be greatly appreciated. We are under a huge deadline.

[kenobewan]

Did you create the table in the stored proc? There is likely to a discrepency between either the table field design or the stored proc. Has the field length changed recently?