Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL doesn't seem to commit
<tarbster_at_yahoo.com> wrote in message
news:1144225356.483214.160150_at_e56g2000cwe.googlegroups.com...
> 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
>
Learn basic SQL. If you want to update a column in a row you need an update
statement. You don't have one so the commit doesn't do anything.
Jim
Received on Wed Apr 05 2006 - 09:17:10 CDT