Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. xtreemnet

    Export to csv file

    Thanks. That helped. Except I kept the Oracle driver same but cast the customer to nvarchar2.
  2. xtreemnet

    Export to csv file

    I am using the oracle provided driver. The customerno is numeric and the type is nvarchar2. When I add the data viewwer on the link from oledb and flat file destination the data looks ok.
  3. xtreemnet

    Export to csv file

    Hi, I am trying to export the output from oracle query to a csv file using SSIS. I have the oledb source and a flat file destination tasks. The output of the csv file randomly strips the first few digits from the first field. Example as below: Query : select customerno, case when type = 'RT3'...
  4. xtreemnet

    Crystal equivalnet next and previous

    Thanks.
  5. xtreemnet

    Failure sending mail

    Hi, I have deployed a report using oracle datasource. The report when run from report manager works fine. But the subscription fails with error: Failure sending mail: An error has occurred during report processing. Have been trying to find solution but could not get one. Can anyone...
  6. xtreemnet

    Crystal equivalnet next and previous

    I am just trying this in the detailed section
  7. xtreemnet

    Crystal equivalnet next and previous

    Hi Is there a equivalent function in RS for Next(field) or previous(field) for accessing data from next or previous row? Thanks.
  8. xtreemnet

    SQL query for CLOB

    If I use just substr then the substr just returns null: SQL> select id, length(rec),substr(rec,32768,1) 2 from items 3 WHERE ID = 'PROD'; ID -------------------------------------------------------------------------------- LENGTH(REC) ----------- SUBSTR(REC,32768,1)...
  9. xtreemnet

    SQL query for CLOB

    I just tried the below and still getting the error: SQL> SET BUFFER 100000 SQL> select id, length(rec), dbms_lob.substr(rec, 32000 ,1) 2 from items 3 where ID = 'PROD'; select id, length(rec), dbms_lob.substr(rec, 32000 ,1) * ERROR at line 1: ORA-06502: PL/SQL...
  10. xtreemnet

    SQL query for CLOB

    Hi, I am trying execute the following SQL: select id, length(rec), dbms_lob.substr(rec, length(rec) ,1) from ITEMS WHERE ID = 'PROD' The length for 'rec' is 3832 characters. The query fails with message : 'ORA-06502 PL/SQL numeric or values error: Character buffer string too small' How do I...
  11. xtreemnet

    Create a connection to Oracle 10g on 64bit windows

    This is getting very funnuy. When I test my connection manager it fails. But my Execute SQL task which uses this connsction works fine. I have created another similar connection manager for Oracle and try to assign it to an oledb component, and it errors out saying 'Cannot acquire connection...
  12. xtreemnet

    Create a connection to Oracle 10g on 64bit windows

    Hi, I can now execute SQL task which uses oracle 10g connection. But i have not been able to connect to an oldeb source component using the oracle connection manager. Any help is appreciated. Thanks
  13. xtreemnet

    Create a connection to Oracle 10g on 64bit windows

    Hi, Can someone tell me the steps to create a connection to oracle 10g on a server which runs on Windows 2003 server(64bit)? I need to update a SQL 2005 table from data on Oracle 10g. Thanks.
  14. xtreemnet

    CLOB greater than 32767 characters

    Hi no worries. I have no privilages to modify the table. I have found another temperrory solution. Instead of passing the whole file, I will find the start position of the srch_str VARCHAR2 parameter in the select query and select the substring of about 500 characters and then extract the...
  15. xtreemnet

    CLOB greater than 32767 characters

    Hi theargtheslayer, I am running this from Oracle's free SQL Developer interface. The table is oracle 10g. For your information if I paste my file in the clob variable the following error is returned: declare rec_string CLOB := 'Paste my file here'; ret_str VARCHAR2(4); len integer...
  16. xtreemnet

    CLOB greater than 32767 characters

    Hi theargtheslayer, select length(dt_clob) from rawfile where id = 162205 Returns: 144943
  17. xtreemnet

    CLOB greater than 32767 characters

    Hi thargtheslayer , The following select: select dbms_lob.getlength(dt_clob) from rawfile where id = 162205 Returns: 144943 ******************************************* And the following select: select dbms_lob.substr(data_clob,dbms_lob.getlength(dt_clob),1) from rawfile where id = 162205...
  18. xtreemnet

    CLOB greater than 32767 characters

    Hi Mufasa, With use of dbmc_lob the following is the output for the column: null MEEN MEEN MEEN TRUS CTCT MEEN MEEN MEEN Please note that the record where its returning null involves the file having size of 142kb. And using substr it gives me 4 characters (which does not tally with expected...
  19. xtreemnet

    CLOB greater than 32767 characters

    Hi Mufasa, Here is my function: create or replace FUNCTION EXTRACT_NT(rec_string CLOB, srch_str VARCHAR2, strField VARCHAR2) RETURN VARCHAR2 DETERMINISTIC IS ret_str VARCHAR2(4); len NUMBER; strText CLOB; SPosICP number; EPosICP number; RetPos number; SPos number; EPos...
  20. xtreemnet

    CLOB greater than 32767 characters

    But the variables in which I would like to fetch the clob has limits I guess.

Part and Inventory Search

Back
Top