Re: PACKAGE EXECUTION help

A copy of this was sent to ZC <zuin_chn_at_my-deja.com> (if that email address didn't require changing) On Tue, 14 Dec 1999 19:39:06 GMT, you wrote:

>I have a package that has a update and delete procedure. When trying to
>run the package, through a reference, the execution is sucessful. When I
>check the table no changes occured. Are the any suggestions on why the
>table hasn't changed. There are to integrity constraints on the table.
>
>this is what is in the package:
>
>UPDATE wpok
>SET x = 'a_variable'
>WHERE y = 'b_variable';
>

in the package add to it:

..
  update wpok
  set x = 'a_variable'
  where y = 'b_variable';

  dbms_output.put_line( sql%rowcount || ' rows updated' ); ..

run the packaged procedure in sqlplus with "set serveroutput on" enabled. see how many rows are updated.

Are there any rows in the table where y equals the STRING 'b_variable'?

if 'b_variable' really means you are using a VARIABLE, not a constant as you have shown above, is b_variable a VARCHAR and Y a CHAR?

>
>
>any suggestions on what is wrong.
>
>
>thanks ZC
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Dec 14 1999 - 15:05:10 CST