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

Home -> Community -> Usenet -> c.d.o.server -> tables with binary_integer in PL/SQL

tables with binary_integer in PL/SQL

From: Kjetil Skotheim <kjetil.skotheim_at_usit.uio.no>
Date: 1997/01/06
Message-ID: <5ar4ae$ej1@ratatosk.uio.no>#1/1 








How can I easily test if an entry in a table exists?




The following does not work:



declare


  type tt is table of number(10) index by binary_integer;
  brb tt;


begin


  brb(1023):=234;


  if exist brb(1023) then begin


    logg(to_char(brb(1023))); end;
  


end;


/






I could catch exceptions, but prefer to avoid that.



Any ideas?
Received on Mon Jan 06 1997 - 00:00:00 CST












Original text of this message













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