Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: overloading in oracle

Re: overloading in oracle

From: Rudi Demeulenaere <rdm_at_datafront.nospam.be>
Date: Fri, 10 Nov 2000 23:10:23 GMT
Message-ID: <3A0C805B.1F984A9B@nospam.be>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US