OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Store Procedure

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
carashito
Newbie
Newbie


Joined: 04 May 2012
Posts: 3

PostPosted: Fri May 04, 2012 4:14 pm    Post subject: Store Procedure Reply with quote

I have a "store procedure" returns me a "select", how I can use it, because I get an error?
Thanks for your atention
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri May 04, 2012 4:24 pm    Post subject: Re: Store Procedure Reply with quote

carashito wrote:
I have a "store procedure" returns me a "select", how I can use it, because I get an error?
Thanks for your atention


With great care.
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Fri May 04, 2012 5:34 pm    Post subject: Reply with quote

Are you asking how to call a stored procedure from OOo? Well, it looks more like yelling, very odd.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
carashito
Newbie
Newbie


Joined: 04 May 2012
Posts: 3

PostPosted: Sat May 05, 2012 12:42 pm    Post subject: Reply with quote

pitonyak wrote:
Are you asking how to call a stored procedure from OOo? Well, it looks more like yelling, very odd.


sorry for that, can you answer the question, please?
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Sat May 05, 2012 4:58 pm    Post subject: Reply with quote

I think that you missed the most important part of my answer...

Are you asking how to call a stored procedure from OOo?

If so, let me mention that I don't usually use and call stored procedures, and have never done it using OOo. But I figured that if I did not know what you were asking (or was unsure) that others probably were unsure as well.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
carashito
Newbie
Newbie


Joined: 04 May 2012
Posts: 3

PostPosted: Sun May 06, 2012 10:25 am    Post subject: Reply with quote

the matter is this, I used the Excel and could do using sql store procedure and issue of licenses now want to use the OO calc to do the same. please can you help me
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun May 06, 2012 11:19 am    Post subject: Reply with quote

WHY ARE YOU POSTING ALL THIS BULLSHIT WITHOUT ANY TECHNICAL INFORMATION? ARE YOU A TROLL, A SPAMMER OR WHAT?
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Sun May 06, 2012 3:56 pm    Post subject: Reply with quote

These might be useful...

It looks like you can probably do it

http://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/CallableStatement.html

This provides an example:

http://user.services.openoffice.org/en/forum/viewtopic.php?f=21&t=41149

http://www.oooforum.org/forum/viewtopic.phtml?t=57193

Hope it helps!
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group