[program-l] Fw: Re: Flat file in an Oracle SQL procedure
- From: "Eileen Lafond" <Eileen.LaFond@xxxxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Mon, 06 Dec 2004 10:38:46 -0800
Thanks for the information.
I had run the procedure to the screen just to see if Ihad the syntax
correct and I got the following errors:
declare
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 12
line 12 follows and the code that goes with line 12:
12 select ACCOUNT, ORG, BUDGET_YEAR, PROJECT, SCENARIO,
STATISTIC,
13 dollar_amt, stat_amt
14 into V_ACCOUNT, V_ORG, V_BUDGET_YEAR, V_PROJECT,
V_SCENARIO, V_STATISTIC,
15 V_DOLLAR_AMT, V_STAT_AMT
16 from Bp_Budgets
17 where phase = 'PREPARER'
18 and budget_year = '2005';
I have all of the v_ fields declared. I have the spelling correct, Do
you have a clue what is wrong?
The size of the file is 237 and it has about 4400 rows.
Thanks for any help,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
>>> richard_bartholomew@xxxxxxxxxxxxxxxx 12/6/2004 1:40:45 AM >>>
Hi, Eileen
Please see attached - somehow it seems to have got snarled up in our
E-Mail
system!
Regards
Richard Bartholomew
ISOS Database & Middleware
Datacentre
8 Glenogle Road
Edinburgh
EH3 5HW
Tel +44 (0)131-245-1667
Fax +44 (0)131-245-3120
----- Forwarded by Richard Bartholomew/IS/SLC/StandardLifeGroup on
06/12/2004 09:41 -----
Richard
Bartholomew To:
program-l@xxxxxxxxxxxxx
cc:
03/12/2004 09:16 bcc:
Subject:Re: [program-l]
Re: Flat file in an Oracle SQL procedure
Hi, Eileen
I'm on holiday this week, hence the reason for no response to date!
You'll need to spool your output to whatever destination you want, eg
on Unix:
spool /tmp/eileen.txt
call to procedure
spool off
On Windows
spool c:\temp\eileen.txt
call to procedure
spool off
This assumes you are using SQL*PLUS to run the procedure; if you're
using
some other means, you'll need to find out how that application
controls
output.
Regards
Richard Bartholomew
ISOS Database & Middleware
Datacentre
8 Glenogle Road
Edinburgh
EH3 5HW
Tel +44 (0)131-245-1667
Fax +44 (0)131-245-3120
For more information on Standard Life, visit our website
http://www.standardlife.co.uk/
The Standard Life Assurance Company, Standard Life House, 30 Lothian
Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and is
authorised
and regulated by the Financial Services Authority. Tel: 0131 225 2552
-
calls may be recorded or monitored. This confidential e-mail is for
the
addressee only. If received in error, do not retain/copy/disclose it
without our consent and please return it to us. We virus scan and
monitor
all e-mails but are not responsible for any damage caused by a virus
or
alteration by a third party after it is sent.
** To leave the list, send a message to:-
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, send a message to:-
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
