stored procedure execution error

• Katmai Stratovolcano

  Say Hey Kid

  Points: 676

  More actions

  September 10, 2009 at 8:07 am

  #385339

  When I tried to execute 'sp_OAMethod' procedure in SQL 2005, i got the error as '[SQL-DMO] This cache contains no result sets, or the current result set contains no rows.'

  The 'sp_OAMethod' procedure we executed as follows:

  sp_OAMethod @objQueryResults, 'CurrentResultSet', @objCurrentResultSet OUT

  I also enabled 'Ole Automation' from Surface Area Configuration.

  Please give a solution for this.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  September 10, 2009 at 9:57 am

  #1051810

  Where are you defining and instantiating @objQueryResults? You cannot call methods until you have an instantiated object.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]