Stored Procedure Snippets


How to get returning value from a stored procedure

Using a stored procedure as the source in an OLE_DB Source for SSIS, the package can’t detect the output of the stored proc.

12 January, 2013   

Search the source code of all stored procedures.

01 January, 2014   

Example shown here how to call a stored procedured in C#

This stored sql procedure is used to replace a special character (or string) of your field with another string.

18 June, 2012   

An example of Stored PL/SQL blocks

Here are the procedure example to create table. you can call this procedure by command like : call myProc();

05 September, 2011   

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful.

Here's a simple trick to execute a Delphi object's method by name:

Here are the example to create temporary table in a procedure .

31 December, 2011   

How to create a procedure for date calculation

You can define parameters with three types of parameters. 1. IN - The parameter can be referenced by the procedure or function. The value of the parameter can not be overwritten by the procedure or function. 2. OUT - The parameter can not be referenced by the procedure or function, but the value of the parameter can be overwritten by the...

If you want to react on user maximizing or minimizing a Delphi form, use the code.

In Delphi, procedural types (method pointers) allow you to treat procedures and functions as values that can be assigned to variables or passed to other procedures and functions. Here's how to call a function (or procedure) as a parameter of another function (or procedure) : Declare the function (or procedure) that will be used as a...

25 January, 2012   

Delphi Code example how to Cut, Copy and Paste

02 May, 2011   

Procedure which checks the number of eating properly entered in edit box with a comma

Delphi code example for Hide minimized MDI child windows

13 March, 2011   

This program make input type for password.

PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output. The special feature about PL/SQL is that a procedure/function argument can be of input (indicating the argument is read-only), output (indicating the argument is write-only) or both (both readable and...

08 May, 2012   

Here shown an example for how to clone a Delphi Form