Databases :: Detecting Nulls In Output Parameter Using ODP?
May 17, 2010
I'm converting my application from using System.Data.OracleClient to Oracle.DataAccess.Client and I've noticed some weird behavior.
I am calling a stored procedure that sets an output parameter value. Under some circumstances, a null value gets assigned to this value and I need to detect it.
Here's how I'm declaring it using ODP.net:
cmd.Parameters.Add("p_status", OracleDbType.VarChar2, 200, DBNull.Value, ParameterDirection.Output)
The old Microsoft driver for Oracle would read the value as an empty string. However, ODP is returning a value {null} (per Visual Studio's debugger), which is not equivalent to null, DBNull.Value, nor an empty string. As a result, the code doesn't branch correctly now.
View 1 Replies
Similar Messages:
Mar 19, 2010
I am using a cursor to iterate through a small set of record (28), perform some maths on each record and then update the record / row.
The problem is the cursor pulls in all nulls for every field in every row
It also gives me 28 rows, 28 times (see below)
[code]......
View 1 Replies
Apr 12, 2010
environment: VS2008, MySQL 5.1.45, .net Connector 6.2.2
Error msg:
NoNullAllowedException: Column 'idNames' does not allow nulls.
The MySQL DB has on "idNames" (Primary Key) a tick-mark for: primary Key, Not Null, Auto-Increment Also: I can add/retrieve records via the 'MySQL Query Browser'; I see the data via VS2008 'Preview Data'!
As said in the comment below; when the 'idNames' is explicitely given the rows.add works fine. So it seems that I miss something around the 'auto-increment' business!
[code].....
View 2 Replies
Mar 5, 2010
I've started using Enterprise Library and have the following questions:1)How do I add output parameter to this query and how do I get it back:
public int InsertDoc(HDocument document)
{
Database db = DatabaseFactory.CreateDatabase();
int result;
var reader = db.ExecuteNonQuery("sp_InsertDocument",
document.AddedDate,document.AddedBy, document.Title))
.
.
.
}
The db.AddOutParameter requires paremetrers that I don't have like DbCommand.2)I have a few methods that work with database (I transfer from ADO.net) stored procedures, do I have to declare : Database db = DatabaseFactory.CreateDatabase(); in each one of them or I can reuse it?
View 1 Replies
Jan 10, 2011
instead of returning my output paremeter value in my stored procedure to my label it returns the default value i set my output parameter to. why cant i put my output parameter into my text label
Dim reader As SqlDataReader
cmd.Parameters.AddWithValue("@tour", "2365")
cmd.Parameters.Add("@tourname", SqlDbType.VarChar)
cmd.Parameters("@tourname").Direction = ParameterDirection.Output
[code]...
View 1 Replies
Feb 7, 2011
I am trying to return output parameter from stored procedure.
Here is my code:
protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();........
View 2 Replies
Dec 14, 2010
I am using LINQ.I have stored procedure as:
ALTER PROCEDURE [dbo].[usp_ATI_OA_GetCalculatedValue]
@OredrID BIGINT = 0,
@SubTotal MONEY OUTPUT,
@ShippingTotal MONEY OUTPUT,
[code]...
The problem is that, how to return OUTPT value to dTtoal and the remaining. Because now it's show assigned values as 1, 2, 3, 4 resp. I mean the bold values.But, if I execute SP using EXEC then it works fine, shows result correctly.
View 3 Replies
Aug 4, 2010
I have a stored procedure with output parameter. I encapsulate it with Table Adapter and BLL. Call it using ObjectDataSource in conjuction with formview, just like the one in Data Access Tutorial. How do I get the output parameter in event INSERTED of the ObjectDataSource in code behind (VB)?
My stored procedure looks like this:
[Code]....
My BLL code looks like this:
[Code]....
View 2 Replies
Jul 12, 2010
We have a stored procedure which creates and returns as output the next value in line:
[Code]....
Yes, the dullards who created this system not only failed to use an identity for the primary key of this table, they then proceeded to add 1 to a varchar column to create the new value, thus insuring it can never be anything but numeric.
Sigh. I'm told we cannot address that obvious deficiency now, and we have to leave the column as varchar. Double sigh.
If I execute this sproc from SSMS, the hh_num variable is returned as expected:
[Code]....
However, when I run it through the application, the parameter I set up as output does not get its Value attribute changed:
[Code]....
I've verified that the "@hh_num" maintains its direction and name through the ExecuteNonQuery call, but its Value remains an empty string.
View 1 Replies
Feb 24, 2011
I am trying to return a sum total figure from a stored procedure by using the output parameter. When I execute the stored procedure in SQL it returns 0 or a valid number like it should but when I try to use the webmethod listed below I keep getting a 0 even when I should get a valid number back.
ALTER PROCEDURE spGetCustSum
@CustomerCode CHAR(4),
@Sum AS INTEGER OUTPUT
AS
BEGIN......
Am I missing a step or have some wrong code in this method?
View 4 Replies
Oct 7, 2010
how do I add an output parameter to a Stored Procedure that returns a code or string to the calling app
View 1 Replies
Jul 30, 2010
I am having some trouble with the below code snippet. It is a stored procedure which executes on load that has an output parameter which should display in a label. Familiar which Vb however not so much in C#.
View 2 Replies
Jan 26, 2011
How can i check if an output parameter is null before i bind it to a asp literal, and if it is null i want to just make the literal
hname1.Text = cmd.Parameters("@hotel1").Value
hname1.DataBind()
hname2.Text = cmd.Parameters("@hotel2").Value
[code]...
View 1 Replies
Oct 11, 2010
m trying to capture an output parameter from an SQL insert.for
CREATE TABLE [dbo].[Test](
[TestID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[Test1] [int] NULL,
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
INSERT INTO [Test] ([Test1]) OUTPUT inserted.TestID as TestOut VALUES 1))
[code]....
View 3 Replies
Apr 15, 2010
I have a gridview that has the header row modified in order to add new records; the gridview is bound to a sqldatasource control. In my code behind, i handle the insert in the following manner:
[Code]....
I know the insert is occuring because the new record shows up in the grid after the databind, but the output parameter is not picking up the scope_identity() value...what am i doing wrong with the output parameter?
View 2 Replies
Oct 15, 2010
Is there a tutorial on a way to query an excel and have the output displayed for the user?
View 2 Replies
Sep 17, 2010
I have a GridView sourced by a SQL Server stored procedure with several databound fields, including a money column for item values. My stored proc returns the data through a SELECT and everything looks good. The stored proc also has a single output parameter that sums the total value of the displayed data, and this value is displayed in a label above the GridView.
View 7 Replies
Jan 18, 2011
i like to pass two i/p parameters to the SP and fetch 2 output parameters.This should done using simple ADO .NET code.
View 1 Replies
May 22, 2010
[Code]....
How do I get the "NewID" parameter value form the above datasource and assign it to a select parameter in a different sqldatasource?
View 2 Replies
Dec 1, 2010
in order to allow my design to keep recently inserted record on a formview i decided to use an output parameter.Currently I have a data layer helper and a class that allows my table to have crud operations.
I have modified my insert stored procedure to the following:
ALTER PROCEDURE [dbo].[InsertContratos]
(
@Contrato int,
@Persona int,
@FechaLegalizacion datetime,
@Vendedor smallint,
@Programa smallint,
[code]...
View 3 Replies
Mar 2, 2010
My stored procedure requires an input parameter -- @CompanyName -- and has one output parameter - @CompanyID. This is how I always handled stored procedures that did NOT use output parameters. How do I grab the value coming from the output parameter?
[Code]....
View 14 Replies
May 6, 2010
I have stored procedure that increments a number. I am supposed to use the newly generated number and insert it into a table. My question is how do I execute the stored procedure, with a hardcoded value of 3 that it expects as a paramter, receive the number it generates as the output parameter and use it in the insert statement.
Here is the stored procedure code:
CREATE PROCEDURE [dbo].[Generate]
@myid int,
@next_no int output
AS
update mytable
set mynumber=mynumber + 1, @next_no = number
where myid=@myid
RETURN
Here is my insert statement, that I tried and it failed:
EXEC @GetNo = Generate '3'
Insert into customers (custid, name, phone ) values
( @GetNo, 'MSFT', '800-345-5678')
View 5 Replies
Aug 10, 2010
I am trying to get the uniqueidentifier value from a insert SP and retreive that using a sqldatasource and pass that value to store files in the relevent folder.
the SQL stored procedure
ALTER PROCEDURE [dbo].[sp_InsertIPRT]
@Site nchar(10),
@Description nvarchar(MAX),
@Application nvarchar(MAX),
@Coordinator nchar(50),
@ProjectNumber nchar(50),
@Manager nchar(50),
@DateRequested date,
@DateRequired date,
@Issues nvarchar(MAX),........
View 2 Replies
Nov 4, 2010
I always thought we had to use a DataReader or a Dataset to read a given SQL data but i realized that it is not necessary to use them to read an SQL Output Parameter(im not a SQL expert).
View 1 Replies
Apr 23, 2013
I have article.aspx page that there is some Textboxs and fileupload control and insert when users click on btnInsert their data insert into database below is Behind code
protected void btnInsert_Click1(object sender, ImageClickEventArgs e)
{
string path = Server.MapPath(".") + "../image/House/article/pdf";
string filename = System.IO.Path.GetFileName(fuppdf.PostedFile.FileName);
string[] validext = { ".pdf" };
string ext = System.IO.Path.GetExtension(fuppdf.PostedFile.FileName);
if (Array.IndexOf(validext, ext.ToLower()) < 0)
[code]....
View 1 Replies