How to call a Oracle Package in PB WITHOUT THE OWNER?

Terry Dykstra

unread,

Jul 10, 2003, 2:00:29 PM7/10/03

to

Define a (public) synonym for the package.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com

"Luiz Alexandre Schafer" <lsch...@rge-rs.com.br> wrote in message
news:#7YTCXwRDHA.314@forums-2-dub...
>
> Hello,
>
> is there a way to call a oracle package for datawindow update without the
> package owner of the database?? PB only shows me the list os packages
whith the
> owner, but I need without the owner!!!
>
> I hope someone knows how to solve it!!!
>
> Thanks in advance!!!
>
> PB version: 8.0.3 Build 9704
> Oracle 8.0.5.2.1
> OS: Windows 2000
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp

Luiz Alexandre Schafer

unread,

Jul 10, 2003, 1:07:34 PM7/10/03

to

Luiz Alexandre Schafer Filho

unread,

Jul 10, 2003, 2:24:12 PM7/10/03

to

On Thu, 10 Jul 2003 12:00:29 -0600,
in powersoft.public.powerbuilder.powerscript

But I扉e already done this! PB dont show the public synonym of a package.
I扉e already tried set up the option "Qualify public synonyms" and it didnt work
too.

Terry Dykstra

unread,

Jul 11, 2003, 11:02:52 AM7/11/03

to

Open a case with Tech Support. If they don't know about it, they won't
fix/enhance it. This forum is for end-users and is not the place to submit
bugs/enhancement requests.
http://casexpress.sybase.com/cx/cx.stm

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com

"Luiz Alexandre Schafer Filho" <lsch...@rge-rs.com.br> wrote in message
news:uWoPUW6RDHA.238@forums-2-dub...
> But I am already connected whith the user which is the owner of the
object.
>
> Thanks for all of you that send me some tips.
>
> I think it is not possible select the package whithout the owner directly
from
> the painter.
>
> I found a way: I export the source code of the datawindow and remove the
owner
> and then import the code.
>
> I hope that Sybase can release a new version which I can select if a I
want with
> or without the owner of the object.
>
> If I am mistaken and someone can prove me that there is a way in PB 8,
please
> send me an email in private.
>
> Thanks.
>
>
>
>
> On Fri, 11 Jul 2003 08:29:35 +0200,
> in powersoft.public.powerbuilder.powerscript
> Bruce H <Bru...@nospam.com> wrote:
> >GRANT Select on psynonym TO ...
> >
> >"Luiz Alexandre Schafer Filho" <lsch...@rge-rs.com.br> wrote in message
> >news:%23Wwa3BxRDHA.238@forums-2-dub...

Bruce H

unread,

Jul 11, 2003, 2:29:35 AM7/11/03

to

GRANT Select on psynonym TO ...

"Luiz Alexandre Schafer Filho" <lsch...@rge-rs.com.br> wrote in message
news:%23Wwa3BxRDHA.238@forums-2-dub...

Luiz Alexandre Schafer Filho

unread,

Jul 11, 2003, 8:11:36 AM7/11/03

to

But I am already connected whith the user which is the owner of the object.

Thanks for all of you that send me some tips.

I think it is not possible select the package whithout the owner directly from
the painter.

I found a way: I export the source code of the datawindow and remove the owner
and then import the code.

I hope that Sybase can release a new version which I can select if a I want with
or without the owner of the object.

If I am mistaken and someone can prove me that there is a way in PB 8, please
send me an email in private.

Thanks.

On Fri, 11 Jul 2003 08:29:35 +0200,
in powersoft.public.powerbuilder.powerscript
Bruce H <Bru...@nospam.com> wrote: