"Sub Routine" Functionality Within Oracle

From: <pmmgpgp_at_gmail.com>
Date: 2 Nov 2006 06:11:26 -0800
Message-ID: <1162476686.036608.140490@i42g2000cwa.googlegroups.com>

I have a basic understanding of Functions and Procedures.

I need to use one or the other as a sub routine ( I need to pass it no value and need nothing returned ). I can do with either Function or a Procedure but Oracle gives me "Hints" such as the following; that I would like either not to happen or need to know how to resolve (have a clean compile). I can use the errors to get to the areas Oracle recognizes as problems but can't determine what I need to do to get Oracle to think I've "used" the variable.

Thanks
Dave

Error: Hint: Value assigned to 'ret' never used in 'cr_data_retention' Line: 842
Text: ret := step07_Apply_min_term('nada');

Error: Hint: Variable 'Trunk_Them' is declared but never used in 'step00_trunc'
Line: 128
Text: Trunk_Them varchar2(1) :=
pkg_cr_Cust_Retention_data_BSC.Truncate_test_Tables('Y'); Received on Thu Nov 02 2006 - 08:11:26 CST