Re: Can this even be done through ADO for Oracle???

Gary:

You may need to reference the proper ADO library. In this case, probably "Microsoft ADO Ext. 2.1 for DDL and Security ADOX" That's under project references, right? Hope this helps,

Carlos.

In article <1aQI3.608$k57.18326_at_news1.teleport.com>,   "Steve Jorgensen" <nospam_at_nospam.com> wrote:
> Can you run a trace to see what is actually being sent to Oracle?
Perhaps
> ADO is adding something to the beginning or end of the statement that
is
> causing it to fail.
>
> Gary wrote in message ...
> >HI All,
> >
> >I am trying to send a "Create Function" statement through ADO to an
> >Oracle Database.
> >
> >The Function gets created but it has Compiler Errors. If I use SQL
Plus
> >to execute the same statement it is successfull with no errors.
> >I can execute the following statements through ADO with no problems.
> >
> >CREATE TABLESPACE
> >CREATE TABLE
> >CREATE USER
> >GRANT
> >ALTER
> >
> >I cannot however Create Procedures, Functions or Triggers through
ADO.
> >If I do I have to go into them using an Oracle Tool such as
> >Enterprise manager to view and edit the code and Apply the changes
> >even if no changes are needed to successfully compile the code.
> >I know the code is Syntacticly correct because I can get the
function to
> >process using SQL PLUS, SQL Worksheet, & Enterprise Manager.
> >
> >Here is an example:
> >
> >Create or Replace Function GAGETEST.Whatserver
> >Return Integer IS
> >BEGIN
> >Return(1);
> >END;
> >
> >This works fine with the oracle tools but not through ADO.
> >
> >Any suggestions would be helpfull
> >
> >Gary
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 17:45:42 CDT