Search results for query: *

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

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.

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'...

Thanks.

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...

I am just trying this in the detailed section

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

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)...

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...

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...

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...

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

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.

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...

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...

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

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...

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...

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...

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