1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

formatting issue while executing SP in SQL Developer

Discussion in 'Other Development Tools' started by lovelysethii@gmail.com, Jan 14, 2015.

  1. lovelysethii@gmail.com

    lovelysethii@gmail.com Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi All,

    While executing a SP in SQL Developer, i am facing formatting problem. such as


    var c1 refcursor
    SET LINESIZE 100
    execute seods01.DS_CGA.get_elec_addr_vld_dtl_rslt('00100000000000070762673','COLA Client Identifier',:c1);
    print c1;

    and the output is:

    anonymous block completed
    C1
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    ELEC_ADDR_TXT SEQ_NBR ADDR_VLD_REAS_TYP_CDE ADDR_VLD_RSLT_STT_TSTP ADDR_VLD_REAS_VAL_CDE ADDR_VLD_RSLT_END_TSTP
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------- --------------------- ------------------------- --------------------- -------------------------
    connor@mail.com 1 EMVLCD0010 08-JAN-15 11.55.10.210999000 PM VALCD00000 31-DEC-99 12.00.00.000000000 AM

    the very first column i.e. ELEC_ADDR_TXT is of varchar2(254) character, please help me with some formatting command to make the output in proper format...
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  3. lovelysethii@gmail.com

    lovelysethii@gmail.com Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    this is related to the version Version 3.2.20.09