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
