473,387 Members | 1,590 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

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.
Mar 7 '07 #1
1 1218
kenobewan
4,871 Expert 4TB
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?
Mar 9 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: jrefactors | last post by:
I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...
2
by: Rhino | last post by:
I am getting an sqlcode of -927 when I execute SQL within a COBOL stored procedure in DB2 OS/390 Version 6 on OS/390. I have looked at the error message for that condition and tried everything I...
1
by: Jawahar Rajan | last post by:
Is it possible for a Dataset that is added to a C# project to be based on a stored Procedure? Can I use either a OracleClient or Microsoft Oracle Client? Any help is appreciated. Jawahar
1
by: lottoman2000 | last post by:
Hello Team.. No, I am not posting in the wrong forum :). I meant to check if the MS pros have read/heard of anything about Oracle Lite 10R2 and its support for .Net Stored Procedure.. Oracle docs...
1
by: Chad | last post by:
Hi, I am a SQL Server programmer using Oracle for the first time. In our .NET client apps which use a SQL Server back end, we would use Stored Procedure exclusively for all database access for...
3
by: =?Utf-8?B?Vmlua2k=?= | last post by:
Hello Everyone, I am trying to call a oracle stored proc from .net code and I am getting an error PLS-00306: wrong number or types of arguments in call to KSSP_MEMBER_NEW. I counted all the...
0
by: =?Utf-8?B?Vmlua2k=?= | last post by:
I am trying to call oracle stored proc in .net. I also want to use enterprise library. when I do db.AddInParameter(dbCommand, "dayPhone", OracleType.VarChar, strList.ToString().Trim()); I get...
8
by: colmkav | last post by:
Can someone tell me how I can access the return value of a function called from Oracle as opposed to a store proc from oracle? my oracle function is get_num_dates_varposfile. I am only used to...
4
by: raghuvendra | last post by:
Hi I have a jsp page with 4 columns: namely Category name , Category order, Input field and a submit button. All these are aligned in a row. And Each Category Name has its corresponding Category...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.