Top "Procedure" questions

A procedure is a subroutine that does not return a value.

PL/SQL: how do I prompt user input in a procedure?

This is a question about a small part of a large project I'm doing. I tried the following but I …

sql oracle plsql user-input procedure
MySQL - Define a variable within select and use it within the same select

Is there a possibility to do something like this? SELECT @z:=SUM(item), 2*@z FROM TableA; I always get NULL …

mysql variables select procedure mysql-variables
Can I execute a procedure with default null parameters?

I recently created a procedure that is defined like this: create or replace PACKAGE pkg_dml_legal_transactions AS PROCEDURE …

oracle plsql procedure
How to make a Clojure function take a variable number of parameters?

I'm learning Clojure and I'm trying to define a function that take a variable number of parameters (a variadic function) …

function clojure lisp procedure
measure time of an sql statement in a procedure in plsql

I must write a procedure which save the execute time of any sql-statement in a table. The procedure is calling …

oracle plsql procedure
Problem with execute procedure in PL/SQL Developer

I this is my first attempt to create procedure and execute it. First I create simple table. DB scheme of …

sql oracle plsql procedure ora-00900
Executing stored procedure in PL/SQL Developer SQL Window

I've used TOAD for awhile, but my dept has asked me to evaluate PL/SQL Developer as a possible change. …

oracle exec procedure plsqldeveloper ora-00900
SYS_REFCURSOR as OUT parameter

I have a table contains (username-primarykey,password,age,gender); have to create procedure like procedure(username in varchar,s_cursor …

oracle procedure sys-refcursor
Get the name of the calling procedure or function in Oracle PL/SQL

Does anyone know whether it's possible for a PL/SQL procedure (an error-logging one in this case) to get the …

oracle function plsql procedure
Error declaring integer variable inside MySQL stored function

I'm getting an error when trying to declare a new stored function in MySQL (Server version: 5.5.13) Basically, I have a …

mysql function variables integer procedure