This discussion is archived
2 Replies Latest reply: Aug 30, 2012 1:28 AM by djeday84 RSS

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

djeday84 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points