ORA-29282 Invalid Id File

[Rosa Isela Silva]

Hello:

I am executing a procedure that open a txt file,
validates, processes and write in an output txt file.
I am using the instructions: UTL_FILE.FOPEN,
UTL_FILE.FCLOSE, UTL_FILE.PUT_LINE.
Even Everithing works perfect I get the following
error everything I execute the procedure.
ERROR at line 1:
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at "BANINST1.A", line 340
ORA-29282: invalid file ID
ORA-06512: at line 1
Any idea about when I get the error if the process
works fine. Last Monday I did not get these message,
last monday the message was of "Procedure executed
Successfully". The message started yesterday.
Thanks

Chao!

Rossita



____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:toad-***@yahoogroups.com
mailto:toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Norman Dunbar]

Hi Rossita,

<snip>

Post by Rosa Isela Silva
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at "BANINST1.A", line 340
ORA-29282: invalid file ID
ORA-06512: at line 1

A couple of questions.

1. When you 'fopen' the file, do you have an exception handler that
traps the error and quietly ignores it, as in :

...
.... = UTL_FILE.FOPEN(...);
...
EXCEPTION
WHEN OTHERS THEN NULL;
END;

If so, remove it and raise the error so that you can see the failure,
act upon it, and act accordingly.

2. What is the code at "BANINST1.A", line 340 doing ? Can we see the
code or it is 'private & confidential'.


I have an online introduction to 'good' use of UTL_FILE here that might
also help.

http://www.jlcomp.demon.co.uk/faq/utl_file.html



Cheers,
Norm. [TeamT]

Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051


Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:toad-***@yahoogroups.com
mailto:toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Booth.Steve]

Nice reference...

________________________________

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of
Norman Dunbar
Sent: Wednesday, February 21, 2007 8:12 AM
To: ***@yahoogroups.com
Subject: Re: [toad] ORA-29282 Invalid Id File




Hi Rossita,

<snip>

Post by Rosa Isela Silva
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at "BANINST1.A", line 340
ORA-29282: invalid file ID
ORA-06512: at line 1

A couple of questions.

1. When you 'fopen' the file, do you have an exception handler that
traps the error and quietly ignores it, as in :

...
.... = UTL_FILE.FOPEN(...);
...
EXCEPTION
WHEN OTHERS THEN NULL;
END;

If so, remove it and raise the error so that you can see the failure,
act upon it, and act accordingly.

2. What is the code at "BANINST1.A", line 340 doing ? Can we see the
code or it is 'private & confidential'.

I have an online introduction to 'good' use of UTL_FILE here that might
also help.

http://www.jlcomp.demon.co.uk/faq/utl_file.html
<http://www.jlcomp.demon.co.uk/faq/utl_file.html>

Cheers,
Norm. [TeamT]

Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally
privileged. If you have received this message by mistake, please notify
the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you
should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to
under the Freedom of Information Act, Data Protection Act or for
litigation. Email messages and attachments sent to or from any
Environment Agency address may also be accessed by someone other than
the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our
terms and conditions which you can get by calling us on 08708 506 506.
Find out more about the Environment Agency at
www.environment-agency.gov.uk

[Norman Dunbar]

Hi Steve,

Post by Booth.Steve
Nice reference...

Thanks. It's a very good web site too. One to book mark.


Cheers,
Norm. [TeamT]



Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051


Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:toad-***@yahoogroups.com
mailto:toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Rosa Isela Silva]

Steve:
Thanks for your response.
To your questions:
1) I dont have any exception to handle when exists an
error when open a file.
2) the line 340 is :ftp_file.fclose(out_file).

--- Norman Dunbar

Post by Norman Dunbar
Hi Steve,

Post by Booth.Steve
Nice reference...

Thanks. It's a very good web site too. One to book
mark.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and
may be legally privileged. If you have received this
message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone
else.
We have checked this email and its attachments for
viruses. But you should still check any attachment
before opening it.
We may have to make this message and any reply to it
public if asked to under the Freedom of Information
Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any
Environment Agency address may also be accessed by
someone other than the sender or recipient, for
business purposes.
If we have sent you information and you wish to use
it please read our terms and conditions which you
can get by calling us on 08708 506 506. Find out
more about the Environment Agency at
www.environment-agency.gov.uk

Chao!

Rossita



____________________________________________________________________________________
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups - Join or create groups, clubs, forums &amp; communities. Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:toad-***@yahoogroups.com
mailto:toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups - Join or create groups, clubs, forums &amp; communities. is subject to:
http://docs.yahoo.com/info/terms/

[Whittle, Jerome S.]

V8.6.1.0.

When I right click on a Blob field in a record viewed in Tables within
the Schema Browser, the Popup Editor brings up Blob Edit. The Load a
File icon is enabled. However when I do the same thing in the SQL Editor
after running a query on the table, the Load a File icon is disabled. Is
this a permissions issue or just something that you can't do through an
SQL statement?

Thanks,


Jerry Whittle
COINS DBA
618-622-4145



<http://geo.yahoo.com/serv?s=97359714/grpId=1103546/grpspId=1705115368/m
sgId=36064/stime=1172066440>


################################################################################

This email transmission contains information from NCI Information Systems, Inc.
that may be considered privileged or confidential and is intended solely for the
named recipient. If you have received this message in error, please contact the
sender immediately and be aware that the use, copying or dissemination of this
information is prohibited.

################################################################################

[Ed Klinger]

There SQl Editor by default is a read only grid. To make it updatable you need
to include the rowid in the select statement

select rowid, t.*
from mytable t

or

edit mytable
where ...

Ed
[TeamT]

_____

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Whittle,
Jerome S.
Sent: Wednesday, February 21, 2007 9:19 AM
To: ***@yahoogroups.com
Subject: [toad] Blob Editor


V8.6.1.0.

When I right click on a Blob field in a record viewed in Tables within the
Schema Browser, the Popup Editor brings up Blob Edit. The Load a File icon is
enabled. However when I do the same thing in the SQL Editor after running a
query on the table, the Load a File icon is disabled. Is this a permissions
issue or just something that you can't do through an SQL statement?

Thanks,


Jerry Whittle
COINS DBA
618-622-4145



<http://geo.yahoo.com/serv?s=97359714/grpId=1103546/grpspId=1705115368/msgId=360
64/stime=1172066440>

_____

This email transmission contains information from NCI Information Systems, Inc.
that may be considered privileged or confidential and is intended solely for the
named recipient. If you have received this message in error, please contact the
sender immediately and be aware that the use, copying or dissemination of this
information is prohibited.

_____



**************************************************************************
Notice of Confidentiality: This e-mail communication and the attachments hereto, if any, are intended solely
for the information and use of the addressee(s) identified above and may contain information which is legally
privileged and/or otherwise confidential. If a recipient of this e-mail communication is not an addressee (or an
authorized representative of an addressee), such recipient is hereby advised that any review, disclosure,
reproduction, re-transmission or other dissemination or use of this e-mail communication (or any information
contained herein) is strictly prohibited. If you are not an addressee and have received this e-mail communication
in error, please advise the sender of that circumstance either by reply e-mail or by telephone at [phone]
immediately delete this e-mail communication from any computer and destroy all physical copies of same.

Replies Filtered: Any incoming e-mail reply to this communication will be electronically filtered for "spam"
and/or "viruses." That filtering process may result in such reply being quarantined (i.e., potentially not received
at our site at all) and/or delayed in reaching us. For that reason, we cannot guarantee that we will receive your
reply and/or that we will receive it in a timely manner. Accordingly, you should consider sending communications
to us which are particularly important or time-sensitive by means other than e-mail.
**************************************************************************

[Whittle, Jerome S.]

Hi Ed,

SELECT rowid, the_blob
FROM COINS_DB.JIM_TEST_BLOB;

That worked!

Jerry Whittle
COINS DBA
618-622-4145
________________________________

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Ed
Klinger


There SQl Editor by default is a read only grid. To make it updatable
you need to include the rowid in the select statement

select rowid, t.*
from mytable t

or

edit mytable
where ...

Ed
[TeamT]

________________________________

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of
Whittle, Jerome S.

V8.6.1.0.

When I right click on a Blob field in a record viewed in Tables within
the Schema Browser, the Popup Editor brings up Blob Edit. The Load a
File icon is enabled. However when I do the same thing in the SQL Editor
after running a query on the table, the Load a File icon is disabled. Is
this a permissions issue or just something that you can't do through an
SQL statement?

Thanks,


Jerry Whittle
COINS DBA
618-622-4145
################################################################################

This email transmission contains information from NCI Information Systems, Inc.
that may be considered privileged or confidential and is intended solely for the
named recipient. If you have received this message in error, please contact the
sender immediately and be aware that the use, copying or dissemination of this
information is prohibited.

################################################################################


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups - Join or create groups, clubs, forums &amp; communities. Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:toad-***@yahoogroups.com
mailto:toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups - Join or create groups, clubs, forums &amp; communities. is subject to:
http://docs.yahoo.com/info/terms/

[Norman Dunbar]

Morning Rossita,

Post by Norman Dunbar

1) I dont have any exception to handle when exists an error when

open a file.
Ok. That means that if the file fails to open for any reason, an
exception will be raised and you should see it (unless some higher up
calling code has an exception handler of course !).

Post by Norman Dunbar

2) the line 340 is :ftp_file.fclose(out_file).

Right, so the 'out_file' variable is presumable the one assigned to at
fopen time. If so, it looks remarkably like something may have changed
the value in out_file so that it no longer applies to any open files.

Is that value used in any other bit of code that could possibly change
its value?

On the other hand, I don't understand this ':ftp_file.fclose(out_file)'
- is that a typo and it should really be 'utl_file.fclose(out_file)' ?

Can you trace the code in the TOAD debugger ?


Cheers,
Norm. [TeamT]




--- Norman Dunbar

Post by Norman Dunbar
Hi Steve,

Post by Booth.Steve
Nice reference...

Thanks. It's a very good web site too. One to book
mark.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and
may be legally privileged. If you have received this
message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone
else.
We have checked this email and its attachments for
viruses. But you should still check any attachment
before opening it.
We may have to make this message and any reply to it
public if asked to under the Freedom of Information
Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any
Environment Agency address may also be accessed by
someone other than the sender or recipient, for
business purposes.
If we have sent you information and you wish to use
it please read our terms and conditions which you
can get by calling us on 08708 506 506. Find out
more about the Environment Agency at
www.environment-agency.gov.uk

Chao!

Rossita



____________________________________________________________________________________
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php


Questions? Try the on-line FAQ:
http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find
out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups - Join or create groups, clubs, forums &amp; communities.
Links





Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051


Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm
Yahoo! Groups - Join or create groups, clubs, forums &amp; communities. Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:toad-***@yahoogroups.com
mailto:toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups - Join or create groups, clubs, forums &amp; communities. is subject to:
http://docs.yahoo.com/info/terms/

[Haricharan Maramraj]

Hi,



I have an xml file and want to convert the content into an Oracle table
using Toad. Could anyone tell me how I can do that? I appreciate that.



Thanks

Hari.



________________________________

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of
Norman Dunbar
Sent: Thursday, February 22, 2007 1:04 AM
To: ***@yahoogroups.com
Subject: RE: [toad] ORA-29282 Invalid Id File




Morning Rossita,

Post by Norman Dunbar

1) I dont have any exception to handle when exists an error when

open a file.
Ok. That means that if the file fails to open for any reason, an
exception will be raised and you should see it (unless some higher up
calling code has an exception handler of course !).

Post by Norman Dunbar

2) the line 340 is :ftp_file.fclose(out_file).

Right, so the 'out_file' variable is presumable the one assigned to at
fopen time. If so, it looks remarkably like something may have changed
the value in out_file so that it no longer applies to any open files.

Is that value used in any other bit of code that could possibly change
its value?

On the other hand, I don't understand this ':ftp_file.fclose(out_file)'
- is that a typo and it should really be 'utl_file.fclose(out_file)' ?

Can you trace the code in the TOAD debugger ?

Cheers,
Norm. [TeamT]

--- Norman Dunbar

Post by Norman Dunbar
Hi Steve,

Post by Booth.Steve
Nice reference...

Thanks. It's a very good web site too. One to book
mark.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and
may be legally privileged. If you have received this
message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone
else.
We have checked this email and its attachments for
viruses. But you should still check any attachment
before opening it.
We may have to make this message and any reply to it
public if asked to under the Freedom of Information
Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any
Environment Agency address may also be accessed by
someone other than the sender or recipient, for
business purposes.
If we have sent you information and you wish to use
it please read our terms and conditions which you
can get by calling us on 08708 506 506. Find out
more about the Environment Agency at
www.environment-agency.gov.uk

Chao!

Rossita

__________________________________________________________
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
<http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php>

Questions? Try the on-line FAQ:
http://asktoad.com/DWiki/doku.php?id=faq:questions
<http://asktoad.com/DWiki/doku.php?id=faq:questions>

Do you know about the other TOAD Yahoo Message Boards? Go here to find
out more - http://www.toadsoft.com/maillist.htm
<http://www.toadsoft.com/maillist.htm>
Yahoo! Groups - Join or create groups, clubs, forums &amp; communities.
Links

Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally
privileged. If you have received this message by mistake, please notify
the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you
should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to
under the Freedom of Information Act, Data Protection Act or for
litigation. Email messages and attachments sent to or from any
Environment Agency address may also be accessed by someone other than
the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our
terms and conditions which you can get by calling us on 08708 506 506.
Find out more about the Environment Agency at
www.environment-agency.gov.uk