Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: overloading in oracle
Thomas Schelhorn wrote:
> Is it possible to get a workarround for this without having to change
> procedure-names.
>
> to make things clearer a short code-snippet:
>
> procedure my_procedure (
> my_parametername1 in my_table.my_column1 %type,
> ...
> )
Another way to solve is would be using dynamic SQL, style
procedure my_proc (
my_par1 in some_type,
my_column_name in user_tab_columns.column_name%type
) is
begin
execute immediate
'some sql here. e.g. set ' || my_column_name || ' = ' || my_par1 || '
more sql ' ;
end;
</rudi> Received on Fri Nov 10 2000 - 17:10:23 CST