Stack Overflow
Stack Overflow

Questions tagged [procedures]

262 questions
3
votes
1 answer

Parsing XML Embedded in VBScript (QTP)

Say there's a QTP Function Library that contains many procedures. Each procedure contains documentation written in an XML node format that describes the purpose, return values and other information about the procedure. Is there a way to parse these…
alvinjorrel
  • 57
  • 1
  • 5
3
votes
1 answer

Calling procedure with updates and a ResultSet in MyBatis

I want to map a SQL Server stored procedure with MyBatis, using annotations. @Select(value = "{call sp_cen_obliczcene(" + "#{wytworId, mode=IN, jdbcType=NUMERIC}, " + "#{rodzajCenyId, mode=IN, jdbcType=NUMERIC}, " + "#{walutaId, mode=IN,…
Barteq
  • 51
  • 4
2
votes
3 answers

How can I reduce this code to a single procedure

I am relatively new to the whole .NET thing, coming from a VB classic background. On my form I have a tabcontrol, with 4 tabs. Most of the code is handled using a shared handler, but for the others I have to write a handler for each. How can I…
Graham
  • 318
  • 1
  • 16
2
votes
1 answer

sp_executeSQL and Statment with more than 2000 characters

I'm using dynamic SQL and I need to exec a long SQL query, First I declare @var with query as nvarchar(4000), but my query is longer than 4000 chars. I try to change to nvarchar(8000) but raise an Exception that can't be longer than 4000…
arturn
  • 725
  • 2
  • 11
  • 25
2
votes
2 answers

How can I share a spawned SSH process between multiple procedures in TCL Expect?

Edit: I've figured it out by referencing the Exploring Expect book. Please don't hesitate to add to my answer or make other suggestions, though! I will mark this as answered when I am allowed to (2 days from now). I've looked around and…
David00
  • 133
  • 10
2
votes
2 answers

Customized Primary Key on SQL Server 2008 R2

I have several days trying to solve this problem, but my lack of knowledge is stopping me, I don’t know if is possible what I am trying to accomplish. I need to have a table like this: The first field should be a custom primary key ID (auto…
pepe
  • 149
  • 12
2
votes
1 answer

Dynamically access column value in record

Is it possible to dynamically access a column value from a record by its name? I'm writing a trigger function that executes a dynamic SQL command and I would like to dynamically extract a column value from a NEW record by column name. Here's a…
Juan Jose Lenero Lozano
  • 95
  • 2
  • 7
2
votes
1 answer

Ask turtles with a lot of who do something in Netlogo

now i have the next problem. Suppose i have a list with diferent numbers for example : let mylist [3 7 12 24 32 54 21 19] And i want to use this list of numbers like the who of turtles. More accurately , i want that only the turtles that his who…
Paul
  • 189
  • 6
2
votes
2 answers

Ask a random number of turtles to do something?

I have two procedures for turtles but I need a random number of turtles to do one of the procedures and another number of random turtles to do the other procedure in equivalent parts. So suppose i have a population of 40 turtles and I have the…
Paul
  • 189
  • 6
2
votes
2 answers

Set table names using user-defined variables in MySQL stored procedures

I want to create a table with a name taking from a user-defined variable. The following code doesn't seem to work (I get a MYSQL syntax error near CREATE TABLE line) Thanks in advance for the help SET @ratingsNewTableName = CONCAT('ratings_',…
chzigkol
  • 23
  • 1
  • 4
2
votes
3 answers

Lists as arguments in Scheme

Let's say I have a procedure foo that takes three arguments, and returns a list of them all doubled: (define (foo a b c) (list (* 2 a ) (* 2 b) (* 2 c))) What I'd like to be able to do is create another procedure which accepts a list, and calls…
Cam
  • 14,930
  • 16
  • 77
  • 128
2
votes
2 answers

Calling an Oracle procedure within a package from a different schema?

I've created the following package with 3 procedures: CREATE OR REPLACE PACKAGE PQ_PaqueteIntegrantes AS PROCEDURE INTEG_INSERCIONES(paIdIntegrante IN CreadorTablas.INTEGRANTES.ID_INTEGRANTE%TYPE ,paNombre IN…
César Villanueva
  • 89
  • 2
  • 2
  • 5
2
votes
1 answer

NetLogo: choose a procedure in setup?

In my model the behaviour of turtles is defined by a combination of different procedures, depending of setup parameters. Let's say I have a code: to go ask turtles [ if (parameter1 = "A") [behaviour-1A] if (parameter1 = "B")…
Marta Cz-C
  • 759
  • 1
  • 8
  • 18
2
votes
1 answer

Type bound procedure as arguments

I want to pass a type bound procedures (as an external function) to another function as follows: module mod1 implicit none type type1 real :: a contains procedure,pass :: f end type contains real function f(y,e) …
PeMa
  • 1,559
  • 18
  • 44
2
votes
7 answers

passing multiple parameters to sql procedure as a single string variable

From front end(studio 2008) I am passing values to sql procedure as : string a = "hello" + "098765" + "world" + "90.0909" These are 4 different values that I've concatenated into a string a; now i pass this string a to the sql procedure using c#…
Swati
  • 2,870
  • 7
  • 45
  • 87
1 2
3
…
17 18