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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Create function withou using utl_file_dir ?

Re: Create function withou using utl_file_dir ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/26
Message-ID: <962031444.21778.0.pluto.d4ee154e@news.demon.nl>#1/1

Couldn't you just use
:new.<column_name> := upper(:new.<column_name>)

Why so difficult?
Am I missing something?

Regards,

Sybrand Bakker, Oracle DBA

"Bernard Polarski" <bpolarsk_at_yahoo.com> wrote in message news:8j798a$154$1_at_nnrp1.deja.com...
> Hello,
>
> Is it a way to create a function or a procedure from within a package,
> compile it, without using utl_file_dir ? I would like to have a trigger
> modify a case in a user defined function whenever rows mutates.
>
> --
> B.Polarski
>
> The 'world of Smenu' is at http://www.geocities.com/bpolarsk
> Email : bpolarsk_at_yahoo.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jun 26 2000 - 00:00:00 CDT

Original text of this message

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