User Profile

Collapse

Profile Sidebar

Collapse
singharvind
singharvind
Last Activity: Jan 17 '08, 10:15 AM
Joined: Jan 17 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • singharvind
    replied to Utl file
    in Oracle
    [code=oracle]
    DECLARE
    vfile UTL_FILE.file_t ype;
    vdata VARCHAR2 (32767);
    vfilename VARCHAR2 (100);
    vsystime VARCHAR2 (10);
    CURSOR wcspolicydetail s IS SELECT * FROM inf_wcs_policy_ sub_tab
    WHERE wcsb_pol_tracke r_id = 489 AND wcsbph_record_t ype IN (2, 3);
    BEGIN
    vsystime := TO_CHAR (SYSDATE, 'hh24miss');
    vfilename := 'ARVINDPOL164.W CA' || vsystime;
    vfile := UTL_FILE.fopen ('WCS_DIR',...
    See more | Go to post
    Last edited by debasisdas; Jan 17 '08, 11:02 AM. Reason: Formatted using code=oracle tags

      Leave a comment:

    • singharvind
      started a topic Utl file
      in Oracle

      Utl file

      Hi All,

      I've a problem with the utl file.

      I'm using put_line to write the lines into the file.

      The problem is that I'm getting new line character at the end of each line which i dont want.

      How to solve this problem?
      See more | Go to post
      No activity results to display
      Show More
      Working...