Re: Update Command in a PL/SQL Procedure

Courtney,

What error message do you get.?

A small point might be when referring to a form field you should use :BLOCKNAME.FIELDNAME as the syntax.

Rob Dickens
OCP Developer
For practical advice and tips on becoming an OCP developer go to www.btinternet.com/~rob.dickens/OCP.htm

Courtney Wright wrote:

> 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 - 14:07:30 CDT