Home -> Usenet -> comp.databases.oracle -> Re: [newbie] select records, update with procedure

Re: [newbie] select records, update with procedure

From: Chris Cowles <NoSpam_at_For.me>
Date: Mon, 2 Aug 2004 19:44:40 -0400
Message-ID: <xlAPc.302$bi.25_at_bignews1.bellsouth.net> 






Mark -



Thanks for the time spent responding.



I found to_date() discussed in other threads. Those explained sufficiently
what my formatting problems were.



It sounds like the select 'execute....' may be the most efficient method. I
can work on generating the select statement without the 'execute
my_procedure(..' part to get the field syntax right, then add the execute
statement.



If a field already contains a date/time, can I just pass it, unformatted? Or
do I have to format the text output back through to_date, before passing it
to the execute statement?



"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message > > Questions:




> >"Chris Cowles" <NoSpam_at_For.me> wrote in message

news:<E8VOc.2903$U23.2375_at_bignews5.bellsouth.net>...


> >

> >  [truncated]

> > 1. How should I format this date field?

> >

> > 2. Is there a simpler way to accomplish this?

> >  [truncated]


> >

> Chris, Oracle normally expects character date strings in the format

> 'DD-Mon-YY' unless otherwise specified.

>

> You can use SQL via SQLPLUS to generate execute procedure(parms) to

> perform your updates:

>

> UT1 > select ' execute my_proc('''||fld2||''');'

>   2  from marktest;

>

> 'EXECUTEMY_PROC('''||FLD2||''');'


> -------------------------------------------------------------

>  execute my_proc('1');

>  execute my_proc('2');

>  execute my_proc('3');

>  execute my_proc('4');

>  execute my_proc('5');

>

> You would want to set pagesize 0, set feedback off, set trimspool on

> etc... to keep the execute script file clean

>

> HTH -- Mark D Powell --

Received on Tue Aug 03 2004 - 01:44:40 CEST












Original text of this message