Search Results

Search found 1620 results on 65 pages for 'proc'.

Page 4/65 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Execute sybase stored proc from hibernate

  - by Padmanabh

  I am having issues with executing a simple sybase stored proc from hibernate. The procedure takes some input and returns one record. I tried with the following tag in hibernate mappings file and java code. <hibernate-mapping> <sql-query name="sybaseproc" callable="true"> <return class="Myentity"> …

  Read the article

• Database Programming in C#, returning output from Stored Proc

  - by jpavlov

  I am working at gaining an understanding at how to interface stored procedures with applications. My example is simple, but it doesn't display my columns and rows in the command prompt, instead it display System.Data.SqlClient.SqlDataReader. How do I display the rows from my stored procudure? ----Stored Proc-- ALTER PROCEDURE…

  Read the article

• Why has wireless disappeared after my 12.10 upgrade?

  - by Shay Guy

  I just upgraded to 12.10 on my Lenovo B570 laptop. NetworkManager isn't displaying a submenu for wireless connections at all, even though I downloaded the update through the wireless connection. This displeases me. Stuff I've tried includes: $ sudo modprobe wl FATAL: Module wl not found. $ sudo lspci -nn | grep "BCM" 02:00.0…

  Read the article

• Named query not known error trying to call a stored proc using Fluent NHibernate

  - by Hamman359

  I'm working on setting up NHibernate for a project and I have a few queries that, due to their complexity, we will be leaving as stored procedures. I'd like to be able to use NHibernate to call the sprocs, but have run into an error I can't figure out. Since I'm using Fluent NHibernate I'm using mixed mode mapping as…

  Read the article

• Problem with Keyboard hook proc

  - by Steve

  The background: My form has a TWebBrowser. I want to close the form with ESC but the TWebBrowser eats the keystrokes - so I decided to go with a keyboard hook. The problem is that the Form can be open in multiple instances at the same time. No matter what I do, in some situations, if there are two instances open of…

  Read the article

• why does python.subprocess hang after proc.communicate()?

  - by ccfenix

  I've got an interactive program called my_own_exe. First, it prints out alive, then you input S\n and then it prints out alive again. Finally you input L\n. It does some processing and exits. However, when I call it from the following python script, the program seemed to hang after printing out the first 'alive'. …

  Read the article

• How do I get a single value from a stored proc using Nettiers

  - by Micah

  I have a really simple stored procedure that looks like this: CREATE PROCEDURE _Visitor_GetVisitorIDByVisitorGUID ( @VisitorGUID AS UNIQUEIDENTIFIER ) AS DECLARE @VisitorID AS bigint SELECT @VisitorID = VisitorID FROM dbo.Visitor WHERE VisitorGUID = @VisitorGUID --Here's what I've tried RETURN @VisitorID…

  Read the article

• Check if stored proc exists in ADO.Net?

  - by HeavyWave

  How do I check that a stored procedure exists using ADO.Net? Is there a specific way to do this (apart from executing SELECT OBJECT_ID() and checking the result)?

  Read the article

• Create a ruby Proc from a string

  - by user252787

  I want to define the block as a string, then create the lambda. The following example does not work. Is something like this possible? code_string = "|x|x*2" l = lambda {eval(code_string)} l.call(3) => 6

  Read the article

• sql server script generater stored proc

  - by Kumar

  anyone know of such stored procs to generate scripts for tables/indexex/views/sp's etc.

  Read the article

• How do I get a scalar value from a stored proc using Nettiers

  - by Micah

  I have a really simple stored procedure that looks like this: CREATE PROCEDURE _Visitor_GetVisitorIDByVisitorGUID ( @VisitorGUID AS UNIQUEIDENTIFIER ) AS DECLARE @VisitorID AS bigint SELECT @VisitorID = VisitorID FROM dbo.Visitor WHERE VisitorGUID = @VisitorGUID --Here's what I've tried RETURN @VisitorID…

  Read the article

• SQL Query to get Count within a Stored Proc

  - by sia

  So i need to figure out how i can get a record count value and use that count as a new value to insert into a table. Ex: In My Stored Procedure @Count int What im looking for @Count to equal "select top (1) _fieldName from _someTable order by _fieldName Desc" Finally insert into _newTable…

  Read the article

• How to set Laptop Brightness in Gnome and /proc on Thinkpad W510?

  - by hakre

  I can set the brightness of my laptop screen already via /proc. I can read and change the value. Now I've set the value to 33 and then I went into gnome power management and enabled the option that it should reduce the backlight brightness being on battery. That works, the screen gets darker. If…

  Read the article

• Determine caller within stored proc or trigger

  - by Mike Clark

  I am working with an insert trigger within a Sybase database. I know I can access the @@nestlevel to determine whether I am being called directly or as a result of another trigger or procedure. Is there any way to determine, when the nesting level is deeper than 1, who performed the action…

  Read the article

• SQL Server job (stored proc) trace

  - by Jit

  Hi Friends, I need your suggestion on tracing the issue. We are running data load jobs at early morning and loading the data from Excel file into SQL Server 2005 db. When job runs on production server, many times it takes 2 to 3 hours to complete the tasks. We could drill down to one job…

  Read the article

• SQL Server 2008 Stored Proc suddenly returns -1

  - by aaginor

  I use the following stored procedure from my SQL Server 2008 database to return a value to my C#-Program ALTER PROCEDURE [dbo].[getArticleBelongsToCatsCount] @id int AS BEGIN SET NOCOUNT ON; DECLARE @result int; set @result = (SELECT COUNT(*) FROM art_in_cat WHERE child_id =…

  Read the article

• has_many conditions or proc on foreign key

  - by ere

  I have a has_many association between two models using a date as both the foreign and primary key for each model. It works perfectly one way but not the other. Works has_one :quiz_log, :primary_key => :start_at, :foreign_key => :start_at Doesn't work has_many :event_logs,…

  Read the article

• Conditional Update stored proc is firing a trigger always

  - by schar

  I have a stored procedure that says update table1 set value1 = 1 where value1 = 0 and date < getdate() I have a trigger that goes like CREATE TRIGGER NAME ON TABLENAME FOR UPDATE ... if UPDATE(value1) BEGIN --Some code to figure out that this trigger has been called -- the…

  Read the article

• Knowing the type of the stored proc when invoking from C#

  - by dotnetdev

  I am making a windows service to be able to run operations on a sql server database (insert, edit, etc) and invoke Stored Procs. However, is there a way for me to know the type of the SP? When invoking from C#, I need to knof if it is returning 1 value, or more, or none (so I can…

  Read the article

• Call stored proc using xml output from a table

  - by user263097

  Under a tight deadline and I know I can figure this out eventually but I don't have much time to do it on my own. I have a table that has columns for customer id and account number among many other additional columns. There could be many accounts for a single customer (Many…

  Read the article

• Pass a pointer to a proc as an argument

  - by user146780

  I want to pass a pointer to a procedure in c++. I tried passing this LRESULT(*)(HWND, UINT, WPARAM, LPARAM) prc but it didn't work. How is this done? Thanks HWND OGLFRAME::create(HWND parent, LRESULT(*)(HWND, UINT, WPARAM, LPARAM) prc) { if(framehWnd != NULL) { …

  Read the article

• XML Document straight to Stored Proc Mapping in NHibernate

  - by ZekeTheGeek

  Hello. I'm building a mechanism to take XML data from a queue and call stored procs to save the data from the XML document directly to the database. This seems like something that NHibernate could address, but of course most of the information I find discusses going from…

  Read the article

• oracle's pro*C compiler and gnu C (__builtin_va_list, __attribute__, etc)

  - by Charles Ma

  I'm compiling a database library with pro*C which converts the .ppc library file to a .c file that gcc can use. However, I'm getting a lot of errors in pro*C like the following PCC-S-02201, Encountered the symbol "__ attribute__ " when expecting one of the…

  Read the article

• pro*C in oracle XE

  - by srandpersonia

  I downloaded the free express edition of oracle, Oracle XE. I couldn't find the pro*c compiler in this edition. I read somewhere that oracle 9i client has pro*C, So I presumed that oracle client for 10g XE should have it too and downloaded it. But to my…

  Read the article

• Best way to use PL/SQL Pacakge Cursors from Pro*C

  - by Greg Reynolds

  I have a cursor defined in PL/SQL, and I am wondering what the best way to use it from Pro*C is. Normally for a cursor defined in Pro*C you would do: EXEC SQL DECLARE curs CURSOR FOR SELECT 1 FROM DUAL; EXEC SQL OPEN curs; EXEC SQL FETCH curs INTO…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >