topic Re: Dblink table fields in Application Development and Automation Discussions

Dblink table fields

Former Member — Mon, 04 Jan 2010 17:55:04 GMT

Hello Fella's,

I'm trying to make a program capable to bring the fields description of a table locate on a legacy system. The connection between sap and other system is done through a dblink. The other system is a oracle.

Look what i'm trying.


  DATA: vl_string TYPE char1024.

  CLEAR: vl_string.

  EXEC SQL PERFORMING APPEND_DATA.
    select *
     from USER_TAB_COLUMNS@DBLINK_63
     Into :vl_string
     WHERE table_name = :p_tabela
  ENDEXEC.

*&---------------------------------------------------------------------*
*&      Form  append_data
*&---------------------------------------------------------------------*
FORM append_data.
  WRITE: / vl_string.
  CLEAR: vl_string.
ENDFORM.                    "append_data

Re: Dblink table fields

Former Member — Mon, 04 Jan 2010 18:07:26 GMT

Maybe wasn't clear meu explanation, so I to help, what I really wanna is use the oracle command DESC and presents the result in ABAP report program.

Thx

Re: Dblink table fields

SureshRa — Mon, 04 Jan 2010 23:02:13 GMT

Hi Bruno,

You have posted a question thread, but I couldn't find any question. Can you please let me know what your problem is?

Cheers

Suresh

Re: Dblink table fields

Former Member — Tue, 05 Jan 2010 11:52:50 GMT

It's a exactly a problem. I just wanna is use the oracle command DESC and presents the result in ABAP report program.

So, I tried the code that I already shown, but, it's not working.

Thx anyway.

Re: Dblink table fields

Former Member — Tue, 05 Jan 2010 12:15:03 GMT

Looks like you have not established connection between SAP and your Oracle databse.