Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Errors with Oracle Stored Procedure
Topic Summary: SP runs in db, but Automate reports error
Created On: 03/30/2017 12:10 PM
Status: Read Only
Linear : Threading : Single : Branch
 Errors with Oracle Stored Procedure   - CraigKorinko - 03/30/2017 12:10 PM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 03/31/2017 02:58 PM  
 Errors with Oracle Stored Procedure   - JackDawson - 04/17/2017 10:00 AM  
 Errors with Oracle Stored Procedure   - CraigKorinko - 05/01/2017 04:03 PM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 04/17/2017 10:49 AM  
 Errors with Oracle Stored Procedure   - EricJones - 04/19/2017 05:14 AM  
 Errors with Oracle Stored Procedure   - Leonard Amabile - 04/19/2017 09:59 AM  
 Errors with Oracle Stored Procedure   - N i c k - 10/25/2017 02:06 PM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 10/26/2017 02:55 PM  
 Errors with Oracle Stored Procedure   - N i c k - 10/26/2017 07:25 PM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 10/27/2017 09:07 AM  
 Errors with Oracle Stored Procedure   - RicoLeenarts - 12/07/2017 05:28 AM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 12/07/2017 02:39 PM  
 Errors with Oracle Stored Procedure   - N i c k - 08/03/2018 01:47 PM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 08/06/2018 10:13 AM  
 Errors with Oracle Stored Procedure   - N i c k - 08/06/2018 10:35 AM  
 Errors with Oracle Stored Procedure   - N i c k - 08/06/2018 10:35 AM  
 Errors with Oracle Stored Procedure   - Ricardo Castaneda - 08/06/2018 10:45 AM  
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 03/30/2017 12:10 PM
User is offline View Users Profile Print this message

Author Icon
CraigKorinko
Apprentice (20-49)

Posts: 40
Joined: 08/14/2007

1) The existing SQL Connection settings from v10 don't appear to work in v11. We are using: Provider=MSDAORA.1;Password=####;User ID=####;Data Source=AVJ##; Persist Security Info=True

This works with 10.5.0.56 on the exact same server.

Error: "Connection to the database failed (Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.)."

Same task works without error in v10, from the same machine against the same database.

2) So I tried the OraOLEDB.Oracle provider. Connection occurs and a simple SQL statement runs, but executing a Stored Procedure action does two things.
a) It successfully executes the stored procedure on the database, as I can verify that by watching the active session get created by AMTB.exe and I see the procedure running and completing successfully.
b) Automate returns an error before the stored procedure ends. "Object reference not set to an instance of an object." Automate 11 says the task failed, but it did what I expected it to do on the db side.

Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 930 guests browsing this forum, which makes a total of 930 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2019 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog