Ora-00600 Internal Error Code Arguments To Define Long Fetch
Contents |
back to return to the previous page. Enter your Username and Password
Dblink Between Oracle And Sql Server
to log in. If you have not yet registered, you can register here. Username: Password: Have you forgotten your login information? Mark all read Contact Us · · Top Generated in 0.008 seconds in which 0.002 seconds were spent on a total of 3 queries. Zlib compression disabled.Powered by UBB.threads™ PHP Forum Software 7.4.1p2
Polls :: Message Navigator E-mail to friend LONG to VARCHAR2 conversion using dblink [message #630239] Tue, 23 December 2014 07:44 Jay1 Messages: 12Registered: October 2014 Junior Member there oracle heterogeneous services are database : DB1 and DB2. DB1 has a table with long dg4odbc oracle 12c column. in DB2 need to create table(varchar2) from DB1 table (long) using DBLINK. length of lob is <32
Ora-28545: Error Diagnosed By Net8 When Connecting To An Agent
K. Is there any other option to convert at DB2? - cannot convert long to lob,later lob to varchar2 since we cant use to_lob over db link - used plsql http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=38776 to convert long to varchar,but it is overrunning & ORA-12151: TNS:received bad packet type from network layer,for even 10 records with no results (may be due to dblink) --table on DB1 CREATE TABLE orgnistaion_db1 ( "DateCompleted" DATE, "CompletedBy" NUMBER (10), "COFSTAId" NUMBER (10), "CONNId" NUMBER (10), "CMUId" NUMBER (10), "comment" LONG ); -- code to convert using plsql at DB2 DECLARE http://www.orafaq.com/forum/t/195756/ long_var LONG; var_var VARCHAR2 (2000); BEGIN FOR i IN (SELECT "comment" FROM orgnistaion_db1@source_db_link) LOOP var_var := SUBSTR (i."comment", 1, 2000); INSERT INTO orgnistaion_db2 ("comment") VALUES (var_var); COMMIT; END LOOP; END; -- Dont have access to DB1,so unable to provide data.Table is having less than <20K records. Thanks Report message to a moderator Re: LONG to VARCHAR2 conversion using dblink [message #630240 is a reply to message #630239] Tue, 23 December 2014 07:49 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member https://docs.oracle.com/database/121/SQPUG/apb.htm#i641251 Report message to a moderator Re: LONG to VARCHAR2 conversion using dblink [message #630243 is a reply to message #630239] Tue, 23 December 2014 08:12 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Otherwise the conversion function should be in the same DB than the table with LONG. Report message to a moderator Re: LONG to VARCHAR2 conversion using dblink [message #630250 is a reply to message #630240] Tue, 23 December 2014 12:28 Jay1 Messages: 12Registered: October 2014 Junior Member Thanks BlackSwan,are you sugegsting
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About http://dba.stackexchange.com/questions/14632/access-data-that-is-stored-in-primary-filegroup-on-sql-server-through-dblinks-on Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's sql server how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Access Data that is stored in Primary FileGroup On SQL Server through DBLinks on Oracle up vote 2 down vote favorite I am using dbLinks to fetch data from SQL Server 2008 to Oracle (10g)database. When I fire the command : select * from "test_table"@dbLink oracle to sql Oracle throws error : select * from "test_table"@dbLink Query Execution started at Thu Mar 08 17:57:50 IST 2012 ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from DBLINK ORA-00600: internal error code, arguments: [HO define: Long fetch], [], [], [], [], [], [], []` On further analysis I realized this happens only for tables which have TEXTIMAGE_ON [Primary] (Specifying that text, ntext, and image columns are stored on PRIMARY filegroup) Then I went over the create command for this table which is CREATE TABLE [dbo].[test_table]( [ADJ_ID] [numeric](19, 6) NULL, [ADJ_TYPE] [numeric](19, 6) NULL, [PK_HASH] [nvarchar](255) NULL, [WH_HASH] [nvarchar](255) NULL, [ADJ_REVISION] [numeric](19, 6) NULL, [LAST_MODIFIED_BY] [nvarchar](255) NULL, [LAST_MODIFIED_DATE] [datetime] NULL, [COMMENTFIELD] [nvarchar](2000) NULL, [DATA] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] The same error is not thrown for tables which do not have filegroup specified as PRIMARY or if I have the same table without clause TEXTIMAGE_ON [PRIMARY] Can any one suggest a solution to overcome this error? Thanks The trace content is ` 1.exec sp_unprepare 1 2.SELECT "A1"."ADJ_ID" AS c000, "A1"."ADJ_TYPE" AS c001, "A1"."PK_HASH" AS c002, "A1"."WH_HASH" AS c003, "A1"."ADJ_REVISION" AS c004, "A1"."LAST_MODIFIED_BY" AS c005, "A1"."LAST_MODIFIED_DATE" AS c006, "A1"."COMMENTFIELD" AS c007,