I'm yet new to nhibernate and currently have issue calling oracle stored procedure that takes an input parameter and return a SYS_REFCURSOR. Using Nhibernate 3.0 on Oracle 11.1g.
public class AccountTranx
{
[DisplayName("Entry Date")]
public virtual DateTime? TranxDate { get; set; }
[DisplayName("Description")]
public virtual string TranxDesc { get; set; }
[DisplayName("Amount")]
i get the following error "could not execute query" but when the stored proceuser has been execuated when i view from the sql profiler the following sql code has been run in the profile
Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?
how can I create stored procedure and write my select statement in it, I know how to create dataset then put type stored procedure and assign it to the sp ... what I want is writing my sp... how can I make it ?
check the following code, this is what I want to write put I don't know where or how !
i have a stored procedure with this values and i need just to make a button that will send something to "Equip" column,how to do it? write the values on my webpage and make a button to exec the procedu
I am trying to create the following stored procedure in sql server Lat and Lng are the parameters being passed from c# code behind .But I am not able to create this stored procedureit indicates with error saying undefined column name Lat,Lng
CREATE FUNCTION spherical_distance(@a float, @b float, @c float) RETURNS float AS BEGIN RETURN ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) ) END sqlda.SelectCommand.CommandText = "select *, spherical_distance( Lat, 57.2958, Lng) as distance from business [code]...
I have created stored procedure and student database and also asp.net application for asp.net page but it could not found stored procedure what is the mistake actually I don't no
The database I am using has a schema called EQB and as such, my stored procedures are named as EQB.usp_SelectFunds, EQB.usp_SelectAccount, etc.
On the select tab of the Configure Data Source screen, I choose to use a stored procedure. The dropdown shows my stored procedures, however, the schema name does not show up in front of the stored procedures in the drop down. I see only usp_SelectFunds, usp_SelectAccount, etc.
I select one of the stored procedures and when I click TEST, I get the message that the stored procedure is not found. If I instead choose to use a SQL statement instead on the configuration screen and enter EXEC EQB.usp_SelectFunds and click TEST, it works fine.
Why are my stored procedures not showing up correctly in the stored procedure drop down and how can I fix this?
I have migrated a database from one server to another and following the migration had an orphaned user (WholeSystem_webuser), which has been fixed using the auto_fix option of sp_change_users_login •The WholeSystem_webuser account is used by ASP.NET pages to connect to the database and run stored procedures.
•I can log in to Management Studio as WholeSystem_webuser OK and execute the sp's from there •When I try to run my ASP.NET page it was saying “Can’t find stored procedure [procedure name]” •If I drop the sp and create it as [dbo].[GetContactsCount] instead of [WholeSystem_ webuser]. [GetContactsCount] it says “The EXECUTE permission was denied on the object 'GetContactsCount', database 'WholeSystem', schema 'dbo'.” (which is what I’d expect as the connection string is using the WholeSystem_webuser account??) –does that show that the web user is logging into the database OK?? •If I try and configure the SqlDataSource in VWD to see what it is looking at though, it won’t let me get beyond the connection string window and says “Default schema could not be retrieved for this connection” •I tried setting up a new login/user/connection string but still get the “Default schema could not be retrieved for this connection” error
IN SQL Server: •Users mapped to the login WholeSystem_webuser - WholeSystem_webuser, default schema dbo •User WholeSystem_webuser has default schema dbo and db_dataread and db_datawrite permissions •There is a schema dbo whose owner is dbo, and a schema WholeSystem_webuser whose owner is WholeSystem_webuser
I have stored procedure in my database but its give error "Could not find stored procedure"Is this error occuring when maked error in permision,sp code or connection code
I am trying to re-write an existing asp.net website using MVC with Linq to SQL. A page we have is used to insert new contracts and uses usp_contract_insert to insert a new contract into t_contract as well as t_project. On my dbml file i have dragged t_contract on and then I try to drag usp_contract_insert on top of that and I get the error :- Microsoft Visual Studio
One or more selected database objects return a schema that does not match the schema of the target data class. Nothing has been added to the designer. The stored procedure returns the id of the last project which was inserted. I don't quite follow this and unsure how to go about hooking my Controller up using Linq to SQL to call this stored procedure
I have a stored procedure with 6 input parameter and 4 output parameter. In My asp.net - C# code I execute the stored procedure and return the parameter, first of all it gave me this error :
Procedure or function w_create_order has too many arguments specified. That I'm not sure why is that because the number of parameters is right, the only thing is may be the way that I used is not right.
Second, I would like to show the parameter in the label control in my page, I'm not sure how to do this.
I have a stored procedure with 6 input parameter and 4 output parameter. In My asp.net - C# code I execute the stored procedure and return the parameter. Stored procedure executed correctly, but the return values are empty. I would like to show the return value on the page. Stored procedure works fine and return value in sql manager.
I have a Listview that I want to read the results of a Stored procedure. I have created the DBML object with the table and the stored procedure. When I configure my LinqDataSource on the page I cannot specify the SProc - only the Table. Or do I need to do it in the Listview?
I'm making my first WCF Service and I am unsure which route I should take with stored procedures and Linq to Sql. I understand that I can drag and drop stored procs to my DBML file and call them that way, or call them directly, not using the dbml. Is there a reason why i should choose one over the other?
I am using LINQ to SQL for inserting, updating my DB now i am using stored procedures to do the same,but i dint find any advantages or less code in using stored proc what is the main diff between using stored proc and not using stored proc?