BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Error 70301 (ORA-00900) when calling a store procedure from


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
jorwes
Forum Member
Forum Member



Joined: 10 Mar 2005

Posts: 14
Location: Sweden


flag
PostPosted: Wed Mar 16, 2005 4:56 am 
Post subject: Error 70301 (ORA-00900) when calling a store procedure from

In a workflow we have a Dataflow + a script + a script. The both script call a sql statment.

The second one is:

sql('DS_OMAHA_TOM', 'exec tom.af2order_rep');

and it returns a error:

70301 error (ORA-00901).

When running: exec tom.af2order_rep
from SQL plus on the Jobserver and that works fine.

Suggestions?? Solutions??

// Jorwes icon_confused.gif
New at DI but old at BO products.....
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10591
Location: Germany


flag
PostPosted: Wed Mar 16, 2005 6:16 am 
Post subject: Re: Error 70301 (ORA-00900) when calling a store procedure f

try this:

sql('DS_OMAHA_TOM', 'begin tom.af2order_rep(); end;');

With the rep() brackets? Without?

_________________
Werner Daehn
Product Manager Data Services
SAP AG
�The opinions expressed in this post are my own views and not those of SAP.�
Back to top
Nicolas Hadj-Blaha
Principal Member
Principal Member



Joined: 10 Mar 2005
ASUG Icon
Posts: 481
Location: New Zealand


flag
PostPosted: Wed Mar 16, 2005 6:36 am 
Post subject: Re: Error 70301 (ORA-00900) when calling a store procedure f

Hi Jorwes,

You could also import the stored procedure in your dataflow and easily called it from your script that way:

DS_OMAHA_TOM.af2order_rep();

Nicolas

_________________
Lead Data Architect, Synchrony Global
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0654 seconds using 17 queries. (SQL 0.0401 Parse 0.0009 Other 0.0244)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo