Re: Urgent help required

try this:

create or replace procedure test_proc
as

• declare the variables x1 and y1 with
• the type of the fields fld_x and fld_y in the
• table "tablename" x1 tablename.fld_x%type; y1 tablename.fld_y%type; begin
• first option:
• (here it's important that the where-clause
• only give ONE record!!) select fld_x into x1 from tablename where key=1; select fld_y into y1 from tablename where key=1;
• second option:
• say: normal variable assignment ... x1 := 5; y1 := 17; end;

is this what you want to do?
Rüdiger J. Schulz
rjs_at_berlin.de

"Solidnull, Inc." <andrew_at_solidnull.com> wrote:
>Hi,
>
>Does anyone know how to assign values to variables in pl/sql? Do i have to
>use a constructor in this case and how? e.g. x1 := fld_x ???? For instance i
>do have two fields in my database fld_x. and fld_y and also i have created
>variebles such as x1,x2,x3,x4 y1,y2,y3 and y4 as coordinates in 2d space.
>i.e. (x1,y1) (x2,y2) (x3,y3) (x4,y4) these represent my variables.
>
>With regards,
>
>
>Andrew
>
>

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de