Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rani
Starting Member
2 Posts |
 Posted - 2006-06-24 : 07:07:59
|
| hiIn my form I have one multi line text item. I have some code in d:\emp\dba file.i want to import this code in to the text item.IN WHEN NEW ITEM INSTANCE hte code isdeclare MYFILE TEXT_IO.FILE_TYPE; LINEBUF VARCHAR2(80); BEGIN MYFILE := TEXT_IO.FOPEN('D:\emp\dba', 'R'); LOOP TEXT_IO.GET_LINE(MYFILE, LINEBUF); message('teat'); :block3.DOCUMENT := :block3.DOCUMENT || LINEBUF || CHR(10); END LOOP; EXCEPTION WHEN NO_DATA_FOUND THEN TEXT_IO.FCLOSE(MYFILE); WHEN OTHERS THEN IF SQLCODE = -302000 then LOOP EXIT WHEN TOOL_ERR.NERRORS = 0; MESSAGE(TO_CHAR(TOOL_ERR.CODE) || ': ' || TOOL_ERR.MESSAGE); TOOL_ERR.POP; END LOOP; END IF; END;but it is not diaplyaing any thing.pls help me. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-24 : 07:31:41
|
| You've posted this inSQL Server Forums / Developerand I'm not sure this is related to Microsoft SQL Server? and to be honest I don't really understand what language you are using and thus can't really help very much, sorry!Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Importing a Text File into a Multi-Line Text Item
If you use SQL Server, then refer