Re: [ADMIN] Create Procedure syntax

2000-10-27 Thread Anatoly K. Lasareff
> "S" == Sivagami <[EMAIL PROTECTED]> writes: S> [1 ] S> Hi, S> I have 3 simple questions: S> 1. What is the exact syntax to create a procedure? CREATE FUNCTION name ( [ ftype [, ...] ] ) RETURNS rtype AS definition LANGUAGE 'langname' [ WITH ( attribute [, ...] )

[ADMIN] Create Procedure syntax

2000-10-26 Thread Sivagami .
Hi,   I have 3 simple questions:   1.  What is the exact syntax to create a procedure?   2.  How can I print something to my screen ,e..g, the value of a variable in a stored procedure. Something similar to DBMS_OUTPUT.PUT_LINE in Oracle??   3.  Also, is there any dynamic discussion foru