Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: object programming in sql
"%FULLUSERNAME%" wrote:
> hello everybody out there,
>
> i've made a table of an object "test" with one field "val" an integer, and i
> want to update a record with the procedure "setValue" i created myself, is
> there any means to do so ?!!
> something like "update mytable m set m.setValue(xxx)" or something like this
> !
>
> thanx
I can't imagine why you would ask this question. In less characters than it took to write this post you could have tested the idea and found it worked.
Well provided your update statement was valid.
CREATE OR REPLACE PROCEDURE xxx IS
BEGIN
UPDATE statement here.
COMMIT;
END xxx;
/
Daniel Morgan Received on Mon Mar 03 2003 - 10:16:38 CST