Jump to content

scb

Members
  • Content count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About scb

  • Rank
    Newbie
  1. scb

    Value in a range

    I have a table that contains ranges for each pair of columns id_indicator / id. For example, for the pair id_indicator / id with value Ind1 / 1, if the percentage is 57%; I need to know that this percentage must correspond to the color "naranja" (column color_indicador). What better solution could I implement, please? Thank you very much in advance. Regards,
  2. Hello, I need to do a spooling of data to a file into an oracle directory directly without introducing the path of this oracle directory. Now, We have the oracle directory in an our machine, and I have this: SPOOL "E:\FICHEROS\file.xls"; But the oracle directory is going to be an outside path of our network and i need to point to the oracle directory when I save my file. Is there any solution for doing this (that there is no with UTL.FILE); i.e. with spool command? Thanks in advance,
  3. scb

    Process exception ORA-00913.

    Thank you very much for your response. I agree with you that it's a strange database design (the problem is the communication of table's structure changes with the Company that provides us the data) . I'll perform your proposal of counting the number of columns to solve this problem. Thanks again for everything.
  4. I have a batch process that insert data into tabla2 from table1; but the problem is that tabla1 change its structure sometimes and we are not noticed about this and when inserting data throws an exception ORA-00913: too many values. I need to handle this exception executing a code. I tested with several exception blocks but none catches the exception. declare e exception; e_compilation exception pragma exception_init (e,-913); pragma exception_init (e_compilation ,-6550); begin dbms_output.enable(); INSERT INTO table2 select T.* from table1 T; COMMIT; exception when e then dbms_output.put_line('exception code'); --send_a_mail(); when e_compilation then dbms_output.put_line('exception code'); --send_a_mail(); when OTHERS then dbms_output.put_line('other exception'); end; Note: table2 have less columns than table1 Thanks in advance.
×