Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    1

    Unanswered: Oracle Stored Procedures

    Hi All,

    I have a question with Stored Procedures. Is it possible to build a SP
    that generates a sql which will be used to call different rows of records in sybase database? I was not sure how the ODBC drivers would work here if it can be done.

    thanks,
    Antzcp04

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is it possible to build a SP that generates a sql which will be used to call different rows of records in sybase database?
    Yes it is possible to do so; just like it is possible to poke yourself in the eye.
    However, I would not want to do either.

    >I was not sure how the ODBC drivers would work here if it can be done.
    Oracle ODBC is used to connect to Oracle RDBMS.

    To connect to any remote database you need appropriate client software.
    Oracle RDBMS is server software; not client software.
    You could utilize UTL_TCP, but that would be a lot of programming.

    I suggest a language other than PL/SQL; such as Java or Perl.
    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
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Oracle has a product that is called heterogeneous connectivity that will allow you to setup a database link to a sybase database. Use the following query in google


    heterogeneous connectivity oracle
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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