PL/SQL How do you do an insert with a %ROWTYPE?

From: Brian Childs <brian_at_sun1.claremont.com>
Date: Thu, 24 Mar 1994 17:05:27 GMT
Message-ID: <BRIAN.94Mar24120527_at_sun1.claremont.com>

Hello Oracle Users,

This is what I'm trying to do:

declare

        param lond_param%rowtype;
begin

	param.client 	     := 'FAKE';
	param.start_seconds  := '12';
	param.end_seconds    := '37';
	param.cut_off_date   := to_date('940301','YYMMDD');
	param.must_have_auth := 0;
	param.leading_trunk  := 3;
	param.attendant      := '6624';

	insert into lond_param values(param.*);  <=== Here's the real problem

end;
/

param.* is an error, and nothing I've tried works, so is there a way to do an insert without explicitly naming all of the columns in a values clause?

It would make maintainance of PL/SQL orders of magnitude easier.

Thanks in advance,
Brian

---

Brian Childs Claremont Systems Inc.
brian_at_claremont.com

--


------------------------------------------------------

Brian Childs			Claremont Systems Inc.
brian_at_claremont.com

Received on Thu Mar 24 1994 - 18:05:27 CET