Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and VB

Re: Oracle and VB

From: Nieser <niese_at_nospamok.stratos.net>
Date: Tue, 3 Apr 2001 23:42:39 -0400
Message-ID: <3aca9934$0$11816$f92e4de5@news.stratos.net>

I vaguely remember the following problem with RDO and Oracle Packages:

When executing PACKAGE_NAME.PROCEDURE_NAME from RDO, Oracle assumes that PACKAGE_NAME is the owner of the procedure and not the package name. You need to wrap a procedure around each package sub or function. Again, I'm not sure on this.... But I hope it gives you something to go on.

Nieser

richard.nield <richard.nield_at_ntlworld.com> wrote in message news:8DLw6.1362$MZ2.272747_at_news2-win.server.ntlworld.com...
>
> I have an RDO connection to an oracle database. I need to execute an
> oracle package thru this connection. Does anyone know if this is
 possible?
> The Oracle support Web site indicates that you can run SQL plus
 statements,
> if you have 'Microsoft extensions. Will that enable to run my package?
 If
> so where can I get the MS extensions?
>
> Thanks for any help.
>
>
Received on Tue Apr 03 2001 - 22:42:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US