stored-procedures

stored proc returns no results, but query does.

Hi all, I have just managed to enable full-text searching to make searching for products in my system easier. However, I am using an sp that was built by someone else and it is not returning any results for "Duty Call". In actual fact I am searching for "Call of Duty", a product in the system. If I type "Call of Duty" it does return a r...

error calling nested stored procedures mysql

Hi I m calling a stored procedure inside another stored procedure in MySQL The error i m getting on calling simply using Mysql administrator call sp_update_back_image(2, 3); is: - OUT or INOUT argument 2 for routine void.sp_sel_options_id is not a variable or NEW pseudo-variable in BEFORE trigger The stored procedures... CREA...

TableName using stored procedure in SQL

I have some problems to passing the @TableName inside a Nearby procedure to use in one StoreLocator. I need to get in 3 tables. I have tested using QUOTENAME but the problem is always here. Can someone help me to fix this problem. Thanks ALTER PROCEDURE [dbo].[GetNearbyTable] @Table sysname, @CenterLatitude FLOAT, @Cente...

Stored Procedure Problem

I have a problem with accessing output in the stored procedure below DbParameter DbParm = command.CreateParameter(); DbParm.Direction = ParameterDirection.Output; DbParm.ParameterName = "@SomeValue"; DbParm.DbType = DbType.Int32; DbParm.Value = null; command.Parameters.Add(DbParm); Afte...

Entity Framework 4 - How to Read Multiple Record Sets From A Stored Procedure?

Hi Guys, I have a very simple stored procedure which returns multiple record sets. All of the record sets have aliased columns so they all look the same. E.g. SELECT TOP 10 FooId AS Id, Name As Name FROM Foos SELECT TOP 10 BarId AS Id, Name As Name FROM Bars ... For my EF setup, i'm using POCOs and have my own DataC...

Executing two INSERT an the same stored procedure with a SCOPE_IDENTITY

Hi ! I would like to insert a record into my SQL Server database with a stored procedure and catch the ID of this inserted row (SCOPE_IDENTITY()) to use it in another insert command. Because I would like to execute those two select command the one after the other if the one didn't pass the other didn't pass too ! Any Idea ? Thank you...

Prepared Statements and Stored Procs Used Together

I'm in the planning stages of a Microsoft ASP.NET / SQL Server 2008 based web application and In thinking about database design, I began to think about injection attacks and what strategies I should employ to mitigate the database as a vector for injection attacks. I've heard from various sources that using stored procedures increases s...

Migrating and upgrading Oracle form Solaris to Linux, including stored procedures

Hello, We are planning a migration of an Oracle installation from Solaris to Linux. At the same time we will upgrade to latest version of Oracle. There are a few hundred stored procedures that should be migrated as well. Present version is Oracle SE 9.2. We will still use Oracle SE, potentially with RAC. Is there anything that we mu...

Does anyone know how to link from Safari on iPad to the "Top Charts" tab of the App Store application?

I have tried using the iTunes Link Maker, and also copying the links out from iTunes on OSX (which works in Safari on the desktop but not on the iPad). ...

MySql, .NET, Stored Procedures sharing the current date and time with the calling client

I'm writing a stored procedure to update a table: UPDATE st SET somedate = NOW(); The client of the SP must know the exact date and time generated by the NOW function. There are two options: 1) the client passes an input parameter (called _now) to the SP giving it the current date and time UPDATE st SET somedate = _now; 2) the S...

My project runs fine on local machine, but not on web server

My project is working fine on my local machine but not on the web server. I think it is the stored procedures, because the error that I am getting is: Fatal error: Call to a member function fetch_array() on a non-object in ... The collation of the database is "utf8_general_ci". Just a simple example: I have a stored procedure called...

How to pass XML from C# to a stored procedure in SQL Server 2008?

I want to pass xml document to sql server stored procedure such as this: CREATE PROCEDURE BookDetails_Insert (@xml xml) I want compare some field data with other table data and if it is matching that records has to inserted in to the table. Requirements: How do I pass XML to the stored procedure? I tried this, but it doesn’t work:[...

Entity Framework 4 - Code First and Stored Procedures

Hi, I want to execute stored procedure with one parameter that returns table using EF4 "Code First". I am ok with some DTO just for this purpose, it doesn't have to return entities. I have tried to: a) create edmx file with function import and add it to my ObjectContext like this: protected override void OnModelCreating(ModelBuilder m...

debug sql stored proc in VS 2008 from within asp.net code

I have a SqlDataSource that calls a stored proc. When the page loads a Gridview loads that uses that SqlDataSource. At this time I want to be able to debug the stored proc. I DON'T want to debug the stored proc on it's own. I want to see what values are actually being passed to the stored proc and what it is actually doing. ...

3rd <day_of_week> of the Month - MySQL

I'm working on a recurrence application for events. I have a date range of say, January 1 2010 to December 31 2011. I want to return all of the 3rd Thursdays (arbitrary) of the each month, efficiently. I could do this pretty trivially in code, the caveat is that it must be done in a stored procedure. Ultimately I'd want something lik...

Can't run stored proc from ODBC with multiple output parameters

I'm having trouble executing a stored procedure in ODBC to a DB2 database where a stored procedure has multiple input and output params. If I specify only in input params in the call statement with ? like below, i get "SQL0440 - Routine XXXXXXX in *N not found with specified parameters.". I've changed the output params to be of type 'Ret...

MySQL stored procedure fails when called from R

This procedure works from the MySQL commandline both remotely and on localhost and it works when called from PHP. In all cases the grants are adequate: CREATE PROCEDURE `myDB`.`lee_expout` (IN e int, IN g int) BEGIN select lm.groupname, lee.location, starttime, dark, inadist,smldist,lardist,emptydur,inadur,smldur,lardur,emptyct,entct...

Benchmarking Oracle User Procedures/Functions

Hi Guys! I'm thinking of a way on how to benchmark an Oracle procedure. My idea is this, put a logging function on each part of the procedure you wish to benchmark. Store the time it entered that part. Then, create another app (using PHP) to compute the difference between each execution. The PHP app is needed to make it as layman as po...

Querying a xml in sql server 2008

Hi all, I wan t to upload the xml data to the sql table. I am passing the xml data from .net(c#)(Working fine) code: ALTER PROCEDURE [dbo].[BookDetails_Insert] (@xml xml) AS insert into BookDetails (Pages,Descriptions) SELECT ParamValues.PLName.value('.','int'), ParamValues.PLDEscr.value('.','text') FROM @xml.node...

Error on calling of Stored Procedure

I Create this stored procedure ALTER PROCEDURE [dbo].[Stock_Master_Sp] @common nvarchar(1)='', @PK_ID int=0, @FK_StoneCategory_Master int=0, @FK_StoneType_Master int=0, @FK_StoneName_Master int=0, @StoneSize nvarchar(50)='', @StoneWeight nvarchar(50)='', @FK_StoneShape_Master int=0, @StoneStrange int...