2 Replies Latest reply: Aug 30, 2012 3:28 AM by djeday84 RSS

    pass-through SQL of Heterogeneous Services, create table limited in 8 symb

    djeday84
      hello everyone! while working with pass-through SQL of Heterogeneous Services faced with some restrictions
      declare
      msg varchar2 (200);
      begin
      msg:=DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@dbf('CREATE TABLE 123456789 (fld1 CHAR(10))');
      end;
      /
      names more than 8 symbols are cutted =(
      is there any workaround ?

      ps: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production oel5
      PSU 11.2.0.3.2
      hs are running under 10.2.0.1 x86 on windows 2003