Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Sounds like your Oracle columns are char datatype. Do you have the option of changing the char columns to varchar2 and then triming the contents of the columns? (that would at least deal with the trailing whitespace issue)
    i.e.:

    SQL> CREATE TABLE temp_ggs (col1 CHAR(2), col2 CHAR(4), col3 CHAR(20), col4 DATE, col5 NUMBER);

    Table created.

    SQL> DESC temp_ggs

    ...

    SQL> SELECT 'ALTER TABLE ' || table_name || ' MODIFY ' || column_name || ' VARCHAR2(' || data_length || ');'
    FROM all_tab_columns
    WHERE data_type =
  • Meaning if the field "could" be 30 characters long and only 5 are inserted the other 25 are SPACES! That is so so annoying when I am trying to pull data out.

    Is the issue pulling data from the Delphi front end or from your own perl scripts? If the latter then look at ora_ph_type which should resolve your problem for you. Also check out the ChopBlanks attribute as well - you will almost always want to use it.

    If you are talking about Delphi then please ignore...