| new code in oracle forms 6i [message #458032] |
Wed, 26 May 2010 21:37  |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
HI GUYS
i have inserted values of external sql file into a text item using utl file package.
this is my code.
LOOP
utl_file.get_line(thefile,v_line);
thetextitem:= thetextitem || ' ' || v_line;
END LOOP;
as you can see based from the loop
the value of the file will be read using get line.
and it is concatenated to thetextitem object.
let say's the value of the file is like
CREATE OR REPLACE Procedure sample3(id_no number)
IS
Begin
insert into emp (empno) values (id_no || 12);
commit;
End;
/
since i'm just using concatenation the output is very far from the original arrangment of the code..
i want to know if there is a newline command that i can put to the textitemobject..
thanks
|
|
|
|
| Re: new code in oracle forms 6i [message #458045 is a reply to message #458032] |
Thu, 27 May 2010 00:07  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Did you try to concatenate CHR(10) too? Something likethetextitem := thetextitem || ' ' || v_line || CHR(10);
Also (probably it is not the case, if code you posted is just a sample, but nevertheless): you never exit the loop.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
