Results 1 to 3 of 3

Thread: SQL Server 6.5 to Oracle DB connection.

  1. #1
    Shankar Jayaraman Guest

    SQL Server 6.5 to Oracle DB connection.


    I am having some difficulty to update a record in a table from SQL Server 6.5 to Oracle 7.3 DB.

    Basically I want to write a insert trigger in Sql Server 6.5 table and I want to update the same inserting record to Unix Oracle table. I tried by writing a DLL and use that in SQL Server External Stored Procedure, but I dont know how to pass the parameter for that. Parameter here is record which I want to insert in to Oracle Table.

    Is there any easy way to do that? Did any body did that before? Please help me out.

    Thanks a lot

  2. #2
    Ray Miao Guest

    SQL Server 6.5 to Oracle DB connection. (reply)

    I don't think trigger can do this.


    ------------
    Shankar Jayaraman at 12/19/99 2:11:55 PM


    I am having some difficulty to update a record in a table from SQL Server 6.5 to Oracle 7.3 DB.

    Basically I want to write a insert trigger in Sql Server 6.5 table and I want to update the same inserting record to Unix Oracle table. I tried by writing a DLL and use that in SQL Server External Stored Procedure, but I dont know how to pass the parameter for that. Parameter here is record which I want to insert in to Oracle Table.

    Is there any easy way to do that? Did any body did that before? Please help me out.

    Thanks a lot

  3. #3
    Shankar Guest

    SQL Server 6.5 to Oracle DB connection. (reply)

    Can you please tell me some other way which can do this.

    -shankar


    ------------
    Shankar Jayaraman at 12/19/99 2:11:55 PM


    I am having some difficulty to update a record in a table from SQL Server 6.5 to Oracle 7.3 DB.

    Basically I want to write a insert trigger in Sql Server 6.5 table and I want to update the same inserting record to Unix Oracle table. I tried by writing a DLL and use that in SQL Server External Stored Procedure, but I dont know how to pass the parameter for that. Parameter here is record which I want to insert in to Oracle Table.

    Is there any easy way to do that? Did any body did that before? Please help me out.

    Thanks a lot

Posting Permissions

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