Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: Sql Server Function from Oracle

    All:

    Oracle 10.2.0.4
    Sql server 2005

    I need to to call a PL/SQL function written in sql server from oracle, transparent gateway is used(dblinks).

    when i query a table of sql sever using command select * from abc@TG4MSQL10 its works fine.
    Please help by providing command to call PL/SQL function from oracle using dblink.

    TIA
    Adil

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I need to to call a PL/SQL function written in sql server from oracle, transparent gateway is used(dblinks).
    Since when does SQL Server have/support PL/SQL?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    duplicate - ignore
    Last edited by anacedent; 03-19-10 at 12:12.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    You can't do what you are asking. But I don't think you actually want to do what you are asking.

    If you want to run a tsql function on SQL Server, then create a view on SQL Server. If you are trying to run a PL/SQL function, as I suspect you are, then make sure you have quoted your identifiers. The difference in the way the two handle case will get you every time.

    Code:
    SELECT abc.*, 
      -- calling oracle to_date function
      to_date(abc."ILoveCamelCaseIdentifiers", 'YYYY-MM-DD') AS dt
    FROM abc@TG4MSQL10 abc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •