Stack Overflow
Stack Overflow

Questions tagged [procedures]

262 questions
0
votes
1 answer

Creating procedures, using putty.exe

I am doing an mysql php application and I need to create a procedure to make my foreign keys work fine and also to create a calendar for report purposes. However, I have been trying to create the procedures and it does not works in putty.exe which…
learnerNo1
  • 147
  • 1
  • 5
  • 23
0
votes
2 answers

Failing procedure for testing exception block

I'm testing few procedures which are in production and have added some part in an exception block. I made a copy of those procedure in a test enviorment and I need to raise a exception for testing. What is a simple way or with a minimum code change,…
Pravin Satav
  • 702
  • 5
  • 17
  • 36
0
votes
1 answer

updating date by stored procedure

I have a problem! My task is to count the age of books in my library database. After that call some books as too rare, some rare , and usual using value column. My library table ( ... , age- date , value- date) notice: "age" - is incorrect…
Ievgenii
  • 477
  • 1
  • 5
  • 13
0
votes
1 answer

Website that communicates with Server

I'm a newbie. Im thinking about developing a website that people can be come members of and login. I know that ill need to have a server with a database to store info. What i need to know is, do i just need to create the server host site host it and…
user1881918
  • 33
  • 6
0
votes
2 answers

Delphi: Program Execution and internal procedure/function calling from CMD or using Doubleclick on associated extension

So - recently I run on some problems determining from which way program was called, if in both times parameters is the same - like: /something /something. I associate icon with program at runetime and i can use cmd to call it, but, whenever i…
HX_unbanned
  • 583
  • 1
  • 15
  • 51
0
votes
1 answer

mysql procedure when while case

Create procedure count_loop( p_start int, p_stop int, p_step int unsigned, p_delim varchar(5)) begin declare v_start int ; declare v_stop int ; declare…
user1682055
  • 93
  • 2
  • 3
  • 9
0
votes
1 answer

How to exexute mysql event at a perticular time with out using if

Iam Using following code to run this event using IF CURRENT_TIME() = '23:50:00' But doing so, every second it has to compare the time with server time. can we implement this with out if condistion drop event OEAuditEvent; DELIMITER $$ CREATE…
Praveen Chinthala
  • 185
  • 3
  • 19
0
votes
1 answer

Writing IBM DB2 9.7 inline or compiled sql statements not working

I would like to write "procedures" in DB2 9.7 without defining the "CREATE PROCEDURE" -statement. Apparently this is something called "compiled" sql statement. However, I am having problems in getting valid syntax. E.g. the syntax below does not…
user1340582
  • 19,151
  • 35
  • 115
  • 171
0
votes
1 answer

CREATE PROCEDURE error

I have error in this code, not able to figure where am I going wrong: CREATE DEFINER=`condoleu`@`%` PROCEDURE `sp_user_field_content_mgt`(FieldContentId varchar(50), FieldRef varchar(50),UserRefId varchar(50), description text,photoUpload…
7HUND3RX
  • 175
  • 3
  • 14
0
votes
1 answer

Procedure giving error in mysql

I have tried the following code with and without a delimiter in phpmyadmin. It seems to reject the delimiter when I have present. I am using 1 and 1 hosting and the MySQL version is 5.0 The error code I specifically get is #1064- You have an error…
Robin
  • 69
  • 1
  • 7
0
votes
1 answer

trigger and procedure issue in mySQL

I want to run a specific script(named proc.php file see below) when the system is inserting new record to one my db tables.(i read about that i need for this the UDF lib, i already installed this on my server and it`s working properly) For this i…
Anton Makov
  • 123
  • 3
  • 11
-1
votes
1 answer

Calling a sql procedure inside another procedure

I want to call a procedure inside another procedure when some conditions met. I am facing a problem when calling the procedure inside another procedure. Please help me to get this issue resolved. --- First Procedure ---- create or replace…
user8683439
  • 49
  • 4
-1
votes
2 answers

Can a oracle function return more than one value

I have a confusion regarding the OUT parameter and RETURN type of a function in oracle PL SQL. I have few questions regarding this. Can someone please explain the difference between the two? Can a function have both IN and OUT parameter like a…
abdul shajahan
  • 11
  • 1
  • 2
-1
votes
1 answer

Error trying to add a place holder in SQL function

The purpose of the program: Given the Country Code, Returns the Countries Region. My only error is my _code variable that I am TRYING to use as a parameter for the Code input(Will not tell me what is, see attached pdf). I used a very similar format…
Help_me_help_you
  • 1
  • 1
-1
votes
1 answer

Delphi TTask - one procedure not executed

I try to use TTask to make application responsive when it starts and makes some DB updates. When application starts DB update form starts and performs several procedures in sequence and also show update progress (ProgrssBar1). All procedures are…
Mindaugas
  • 115
  • 2
  • 11
1 2 3
…
17 18