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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can this even be done through ADO for Oracle???

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

From: Steve Jorgensen <nospam_at_nospam.com>
Date: Thu, 30 Sep 1999 13:56:41 -0700
Message-ID: <1aQI3.608$k57.18326@news1.teleport.com>


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
>
>
>
Received on Thu Sep 30 1999 - 15:56:41 CDT

Original text of this message

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