stored-procedures

Doctrine + SQL Server Stored Procedures.

How can I call a stored procedure using Doctrine? ...

How can I tell what the value of a mysql variable is during the execution of a stored procedure

I am having a problem where a stored procedure is taking a long time. We have two variables created @start_date and @end_date from other queries earlier in the script. Is there a way to see what those values are during the execution of the script? The script takes 3 hours to complete when it really shouldn't, I suspect the dates are off...

Why SQL2008 debugger would NOT step into a certain child stored procedure

I'm encountering differences in T-SQL with SQL2008 (vs. SQL2000) that are leading me to dead-ends. I've verified that the technique of sharing #TEMP tables between a caller which CREATES the #TEMP and the child sProc which references it remain valid in SQL2008 See recent SO question. My core problem remains a critical "child" stored pro...

Passing an array of data as an input parameter to an Oracle procedure

I'm trying to pass an array of (varchar) data into an Oracle procedure. The Oracle procedure would be either called from SQL*Plus or from another PL/SQL procedure like so: BEGIN pr_perform_task('1','2','3','4'); END; pr_perform_task will read each of the input parameters and perform the tasks. I'm not sure as to how I can achieve th...

Stored Procedure generator tool

I am looking for tool which will generate the basic stored procedure structure (CRUD operations) for the given table, Is there any tool for the same? ...

Need SQL Server Stored Procedure for This Query

I have a ASPX.NET DataGrid and im trying to USE a select LIKE 'X'% from a table that has 1 field called location. im trying to display the locations that start with a certain letter (example wxxx,axxx,fxxx,) in different columns in my data grid. I am trying to display more than 1 column in my datagrid using a SP shown below. The issue i...

Caching stored procedure results in Linq'u

In our web application we have a lots of stored procedures look like this one: getSomeData(/* 7 diffrent params */) This stored procedure don't make any updates. We are using Linq'u. I know that the date are changing no often than once per day so the results for the same sets of parameters values will be the same. Does Linqu have ...

How to make VB to execute my SQL SP with parameters?

Hi, I have a database in MS SQL Server 2008, I have Stored Procedures. One of them does an INSERT with parameters. It works in Server Management Studio. Now I'd like to make a button in Visual Basic 2008 that executes this SP. I have made a DataSet, it contains my 3 SP's, I can easily use 2 of them, because they return data, but the one...

Is there a way to pass a custom type from C# to Oracle using System.Data.OracleClient?

I was searching online for a solution to passing a string array to a stored procedure in Oracle. The "easy" but messy way was using a comma delimited string. I had found a sample based on which I created my own type of TABLE of VARCHAR2(200). I understood that I could use a constructor created "behind-the-scenes" by Oracle to give a li...

Making flexible C# code in MVC2 for Stored Procedures

Thanks to Darin Dimitrov's suggestion I got a big step further in understanding good MVC code, but I'm having some problems making it flexible. I implemented Darin's suggested solution, and it works perfectly for single controllers. However I'm having some trouble implementing it with some flexibility. What I'm looking for is this; To...

postgres stored procedure problem

Hi all, Ich have a problem in postgres function: CREATE OR REPLACE FUNCTION getVar(id bigint) RETURNS TABLE (repoid bigint, suf VARCHAR, nam VARCHAR) AS $$ declare rec record; BEGIN FOR rec IN (WITH RECURSIVE children(repoobjectid,variant_of_object_fk, suffix, variantname) AS ...

Stored procedure in scheduler in SQL Server 2005

Hi All, I am using SQL Server 2005. I have a stored procedure [say Sp_GetAllMaterialInfo], I want to put it in a scheduler that everyday this stored procedure execute on 2 P.M. daily. Please let me know the steps I have to follow to achieve in SQL Server 2005 Thanks in advance. ...

Why can we not execute a stored procedure inside a function in sql server 2005?

Why can we not execute a stored procedure inside a function when the opposite is possible? ...

SQL Server stored procedures - update column based on variable name..?

Hi, I have a data driven site with many stored procedures. What I want to eventually be able to do is to say something like: For Each @variable in sproc inputs UPDATE @TableName SET @variable.toString = @variable Next I would like it to be able to accept any number of arguments. It will basically loop through all of the inputs a...

Stored Procedure outlining

I have stored procedure (unorganized - not properly outlined) I want automatic outlining in the stored procedure by using VS. ...

using log4net through stored procedures in oracle

hi, My objective is to log in oracle 10g using log4net through stored procedure. I have made configuration in log4net configuration xml file to use ado.net appender and use stored procedure for Logging in db. I want to log exceptions in db with parameters like error code, error message, etc. Please guide me how to pass this Exception ob...

ORACLE: Parameter reference in WHERE doesn't work

Hello, I have created a simple static function in oracle 10g to get the reference of an object based on his pk. STATIC FUNCTION getRef(nome IN VARCHAR2) RETURN REF folder_typ IS fl_r REF folder_typ := null; BEGIN SELECT REF(fl) INTO fl_r FROM folder_tab fl WHERE fl.nome = nome; RETURN fl_r; END getRef; Thi...

How can fill a variable of my own created data type within Oracle PL/SQL?

In Oracle I've created a data type: TABLE of VARCHAR2(200) I want to have a variable of this type within a Stored Procedure (defined locally, not as an actual table in the DB) and fill it with data. Some online samples show how I'd use my type if it was filled and passed as a parameter to the stored procedure: SELECT column_value cu...

Visual Studio 2010 Connect to SQL Server 2000?

We recently upgraded a major application to Visual Studio 2010. Unfortunately, we are still using several database servers that are still running SQL Server 2000 (8.0.2055 to be precise). According to this article (http://blogs.msdn.com/b/habibh/archive/2009/07/27/visual-studio-2010-rip-list-partial.aspx), "Since mainstream support for...

Stored Procedures In Source Control - Automate Build/Deployment Process

My company provides a large .NET service-oriented solution. The services layer interact with a T-SQL back-end consisting of hundreds of tables and stored procedures. Our C# code is in version-control (SVN) but our stored procedures and schema are not. After much lobbying of expedient upper-management, I was allowed to review our (non-ex...