Top "Procedure" questions

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

drop procedure if exists in DB Oracle

Can someone tell me how I can drop a PROCEDURE in Oracle, but just if it exists ? DROP PROCEDURE IF …

oracle procedure
How can I find out where a database table is being populated from?

I'm in charge of an Oracle database for which we don't have any documentation. At the moment I need to …

database oracle triggers procedure
How to stop a running procedure in MySQL?

I called a procedure in MySQL, but it is in an endless loop now! How to stop a running procedure …

mysql procedure
mysql drop table if exists inside procedure

I'm trying to apply a nested set model example with procedures. I've found many of them with this technique and …

mysql procedure sql-drop
Dynamic MySQL Where Clause in Stored Procedure

I have a question and maybe its simple (for you Gurus). I'm transposing my SQL Paging class from C# to …

mysql sql procedure
PL/SQL: Retrieve names of procedures and functions within a package

Is it possible to retrieve the names of all procedures and functions that reside within a particular package? I understand …

oracle function plsql introspection procedure
Correct way to destroy a form and show another in Delphi

Currently in my program I have a Startup form, and a Main form. The startup form shows for a second …

forms delphi procedure creation destruction
How to list out the user defined functions and procedures in PostgreSQL

Trying to find out the stored functions and procedures on PostgreSQL. I found some of the solutions where "join" has …

postgresql list function procedure
Strugging with spring SimpleJdbcCall to call Oracle function

I am struggling with the below code to make it work, searching documentation and forums and stucked. Finally I decided …

java oracle procedure