Home » Developer & Programmer » Forms » Undefined attribute
Undefined attribute [message #195976] Tue, 03 October 2006 07:31 Go to next message
Messages: 4
Registered: October 2006
Junior Member
What is undefined attribute if it doesn't tell you which attribute is undefined? Where do I go? All I'm doing is loading a drop down combo with stuff from a flat file. The data comes in fine. When I select one of the items I put it in a text box so the user can edit it. Then i have an Update button that writes the whole combo box data back out to the flat file substituting the edited one where it is suppose to be. Here is the code. It bombs at the the TEXT_IO_FOPEN(v_dir_file2, 'W') line with an ORA -302001 error which basically means it can't find the file. But it loaded the combo box from the file and I closed it. I'm stuck.
num number(8);
numinlist number(8);
outvar varchar2(100);
out2filevar varchar2(100);

v_dir_file2 varchar2(100) := '\\City_hall\Ch2_data\HR\Osha\oshaemail.txt';
v_file_in2 TEXT_IO.FILE_TYPE;
cnt number(8);
v_string2 varchar2(100);

num := 1;
:text_item26 := '';

if (:text_item10 is null) then
:text_item26 := 'Choose a department from the pull down box to put it in the edit box';

--IT BOMBS HERE :text_item50 := 'start';
v_file_in2 := TEXT_IO.FOPEN(v_dir_file2, 'W');
-- NEVER GETS HERE :text_item51 := 'end';
numinlist := to_number(get_list_element_count('LIST4'));

cnt := 1;
while cnt < numinlist

-- read the list box items and check the dept no with the hidden box :text_item16
-- if they are the same, that is the edited one so concatenate the dept no and the
--edited email and put it back, otherwise just write the one in the list box out
outvar := get_list_element_value('LIST4', cnt);
-- message (substr(outvar,1,6) || ' ' || :text_item16 || ' ' || :text_item10, acknowledge);
-- message (substr(outvar,1,6) || ' ' || :text_item16 || ' ' || :text_item10, no_acknowledge);

if (substr(outvar,1,6) = :text_item16) then
out2filevar := :text_item16 || ',' || :text_item10;
TEXT_IO.PUT_LINE(v_file_in2, out2filevar);


TEXT_IO.PUT_LINE(v_file_in2, outvar);
end if;
cnt := cnt + 1;
end loop;

:text_item26 := 'Email file has been updated with changes';
:text_item10 := '';
-- reload the pull down
num := 1;
-- sw := 0;
-- write the pdf file names from the c:\oshatemp dir to a file called dir.txt
-- then read each one out and get the dept number off of the file name to send email
v_file_in2 := TEXT_IO.FOPEN(v_dir_file2, 'R');
-- now read the directory listing from the file and call sendmail for each file
-- loop through file called oshaemail in oshaemail dir to find email address by looking up dept no

TEXT_IO.GET_LINE(v_file_in2, v_string2);
add_list_element('LIST4', num, v_string2, v_string2);

num := num + 1;
end if;

Re: Undefined attribute [message #196209 is a reply to message #195976] Wed, 04 October 2006 09:08 Go to previous messageGo to next message
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden
Senior Member

I don't think your program / logic will work this way.

After you read file in, and displays the lines, you want to change a line.

But how to get the changed line back in the correct place of the file?

Steps you might try:
1) read the complete file in an associative array.
2) change the element of this ass. array
3) with a host command, delete the original file
4) now write back the contents of the ass. array to a new file that has the name of the original file.

I think this should work.

Why do you not place the data in a table? Much easier then...


Rob Zijlstra
Re: Undefined attribute [message #196544 is a reply to message #195976] Thu, 05 October 2006 20:54 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you defined the output directory in the database?

Previous Topic: frm-40734 internal pl/sql error
Next Topic: help - database triggers and sequences
Goto Forum:

Current Time: Thu Aug 24 03:57:55 CDT 2017

Total time taken to generate the page: 0.01760 seconds