Update Command in a PL/SQL Procedure

From: Courtney Wright <lili96ilil_at_netzero.com>
Date: Thu, 16 Sep 1999 11:23:28 -0400
Message-ID: <aY7E3.89$34.8676@news.oh.voyager.net>

I'm using Forms 4.5...

I have a procedure that uses the SQL Update command to update an Oracle table.

Notes: :IP_TD text field on my form
(Char 30)

                IPIDNo     variable declared in the procedure    (Number 15)
                TaxDist    column in SegCabl


(Number 5)


                IPID          column in SegCabl

(Number 15)

This example works fine...

UPDATE SegCabl SET TaxDist = :IP_TD WHERE IPID = 4215460;

But when I replace the 4215460 with a form text field or a variable of the same value, it doesn't work...

UPDATE SegCabl SET TaxDist = :IP_TD WHERE IPID = IPIDNo; or
UPDATE SegCabl SET TaxDist = :IP_TD WHERE IPID = ( :Form_Text_Field );

I don't understand why I can use a variable or text field in the SET part of the clause but not the WHERE part of the clause. Thinking that it might have something to do with data types, I tried setting IPIDNo to both VarChar and Number but it didn't work. Any ideas?

Courtney Received on Thu Sep 16 1999 - 10:23:28 CDT