Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL table variable initialization

PL/SQL table variable initialization

From: <coneal_at_exis_dotoutspam.net>
Date: 1997/12/07
Message-ID: <348a3874.332735036@news.exis.net>#1/1

I have a program that uses a PL/SQL table as a stack with a counter, varchar2 and a boolean. The stack is built as the program traverses down through FK's from a table. Three out of four instances, all on 7.3.3, will initialize the boolean to null when a new record is added to the stack. The fix is to manually initialize the boolean, but aren't variables initialized to null by default? and how can three "identical" instances initialize the but the fourth not?? Received on Sun Dec 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US