Results 1 to 2 of 2

Thread: direct connect

  1. #1
    Join Date
    May 2004
    Location
    France
    Posts
    16

    Unanswered: direct connect

    Hi all,

    I'm looking how to execute a SP_xxxx from a sybase to an oracle dataserver.

    i installed Direct connect
    i declared the Oracle dataserver in remote server
    i mapped a sybase user (extern login) to an oracle user.

    it seems to Work, i guess i can connect. but how to execute a Proc stock ?

    thnx for any help

  2. #2
    Join Date
    May 2004
    Location
    France
    Posts
    16

    Unhappy

    when i try to exec an sp

    declare @toto int
    declare @tata int
    exec OPE1FRD0..OPEUSR..spu_oais_inveval 100

    select @tata, @toto

    i got thiqs error :
    The procedure name 'OPE1FRD0...OPEUSR..spu_oais_inveval' contains more than the maximum number of prefixes. The maximum is 3.

    upp

Posting Permissions

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