/*---------------------------------------------------*/
/* Example 1: Create an anonymous block */
/*---------------------------------------------------*/
Declare
vShopList Varchar2(25) := 'Apples';
Begin
Dbms_Output.Put_Line ('Buy more '||vShopList);
End;
/
Buy more Apples
/*---------------------------------------------------*/
/* Example 2: Change to a procedure and execute */
/*---------------------------------------------------*/
Create or Replace Procedure pShopList
is
vShopList Varchar2(25) := 'Apples';
Begin
Dbms_Output.Put_Line ('Buy more '||vShopList);
End;
/
Procedure created.
/*-----------------------------------------------*/
/* Run procedure */
/*-----------------------------------------------*/
Begin
pShopList;
End;
/
Buy more Apples
/*---------------------------------------------------*/
/* 3. Change procedure to accept parameter */
/*---------------------------------------------------*/
Create or Replace Procedure pShopList
(vShopList Varchar2)
is
Begin
Dbms_Output.Put_Line ('Buy more '||vShopList);
End;
/
Procedure created.
/*-----------------------------------------------*/
/* Run procedure with input parameter */
/*-----------------------------------------------*/
Begin
pShopList ('Bananas');
End;
/
Buy more Bananas
Saturday, March 14, 2009
Anonymous Block vs Procedure with Parameters
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment