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 -> Re: PL/SQL doesn't seem to commit

Re: PL/SQL doesn't seem to commit

From: Ed Prochak <edprochak_at_gmail.com>
Date: 5 Apr 2006 06:23:31 -0700
Message-ID: <1144243411.440287.20870@z34g2000cwc.googlegroups.com>

tarbster_at_yahoo.com wrote:
> So all things considered, it's not great PL/SQL? ;) That'll teach me
> to trust something in a PL/SQL website tutorial...
>
> Sorry guys. To answer one question: it's running on unpatched 9iR1.
>
> To answer another: what it's trying to do is put a different UID into
> the harnloc1.harnloc1_id column in every row. The value is derived from
> the SYS_GUID function, and reformatted for application reasons.
>
> TIA
> Tarby

Did you not read our replies? As Daniel put it, your original code DOES NOTHING.
Fix your code and try again. (HINT: add an UPDATE statement)

ed Received on Wed Apr 05 2006 - 08:23:31 CDT

Original text of this message

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