Professional Web Applications Themes

Heterogenous queries ERROR 7405 - Microsoft SQL / MS SQL Server

HI Friends, I am trying to use declare s int select s = nextval from openquery(xdev,'select ca.ca_tc_s.nextval from dual') inside my store procedure where xdev is a linked server for OLE Oracle provider. I am getting error Heterogenous queries require the ANSI_NULLS and ANSI_WARNING .......ERROR 7405 What should I do to be able to run my store proc? Everything is working fine on SQL Query yser. Thanks in advance, Pat...

  1. #1

    Default Heterogenous queries ERROR 7405

    HI Friends,
    I am trying to use

    declare s int
    select s = nextval from openquery(xdev,'select ca.ca_tc_s.nextval from
    dual')

    inside my store procedure where xdev is a linked server for OLE Oracle
    provider.

    I am getting error Heterogenous queries require the ANSI_NULLS and
    ANSI_WARNING .......ERROR 7405

    What should I do to be able to run my store proc? Everything is working
    fine on SQL Query yser.

    Thanks in advance,
    Pat


    Patrick Guest

  2. #2

    Default Re: Heterogenous queries ERROR 7405

    When you've created the stored procedure the settings for ANSI_NULLS and
    QUOTED_ITEDENTIFIER would have been off. They should be on at the time of
    stored procedure creation.
    Script the existing stored procedure.
    drop the the stored procedure.

    SET the following options in Query yzer before running the scripted
    "Create procedure" statement.
    SET ANSI_NULLS ON
    SET QUOTED_IDENTIFIER ON
    --Create the stored procedure again.
    CREATE PROC.....


    --
    -Vishal
    "Patrick" <all-in-1.com> wrote in message
    news:phx.gbl... 


    Vishal Guest

  3. #3

    Default Re: Heterogenous queries ERROR 7405

    Thanks




    "Vishal Parkar" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Patrick Guest

Similar Threads

  1. Query of queries Error
    By Tulsa in forum Coldfusion Database Access
    Replies: 9
    Last Post: November 23rd, 12:03 AM
  2. Query Of Queries syntax error
    By Spaniard1981 in forum Coldfusion Database Access
    Replies: 2
    Last Post: August 15th, 01:54 PM
  3. Query of Queries runtime error
    By mike.bacso in forum Coldfusion Database Access
    Replies: 0
    Last Post: April 23rd, 06:27 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139