Re: Running a PlSQL Block under Ksh

From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/05/18
Message-ID: <8VSU4.1$7E1.242_at_wdc-read-01.qwest.net>#1/1


Do you have a COMMIT after the update?
"chris" <vvk0928_at_yahoo.com> wrote in message news:39236EFA.31A0BCEC_at_yahoo.com...
> Hi guys,
> I have a Korn SHell script that I use to execute a Pl/Sql Block. There
 are 2
> Ksh Functions. The first one checks for dups in a Table and marks the dup
> records as invalid. The 2nd function then spools the valid data to a file.
> Everything works fine except for the update statements in the 1st Pl/Sql
 Block.
> That data does not get updated in the table.
> The same Pl/Sal block works fine when I execute it directly under
 Sql*Plus.
> Any ideas /suggestions ?
>
> Thanks
> Venkatesh
>
Received on Thu May 18 2000 - 00:00:00 CEST

Original text of this message