Re: [newbie] select records, update with procedure

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 Mon Aug 02 2004 - 18:44:40 CDT