Spesial Copy of Procedures and functions.

[Petrus]

In the SQL window there is a spesical copy function where the sql state can be turned into a C#, VB variable. This is a nice function that I use a lot.

It would be great if this also was available on the procedure and function level to generate code that can be pasted into the client.

 

[Marco Kalter]

Can you provide an example?

 

[Petrus]

Oracle function:
FUNCTION Is_Numeric(Parameter_ IN VARCHAR2) RETURN NUMBER IS

char_ VARCHAR2(1);
char_counter_ INTEGER;
is_numeric_ NUMBER;

BEGIN

is_numeric_ := 1;
char_counter_ := 0;
WHILE (char_counter_