Dblink table fields

[Former Member]

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

[Former Member]

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

[SureshRa]

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

[Former Member]

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.

[Former Member]

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