gudidi
asked on
Dynamic SQL statement Failed in C# - works fine in TOAD
Hi Experts
i try to recompile invalid objects of Oracle from C# application.
on TOAD and SQL+ it works fine
from C# i get error of : ora-0900 sql invalid statement\n
this is the script: EXEC DBMS_DDL.alter_compile('PR OCEDURE',' DD20','RAN GE1');
10x in advance
i try to recompile invalid objects of Oracle from C# application.
on TOAD and SQL+ it works fine
from C# i get error of : ora-0900 sql invalid statement\n
this is the script: EXEC DBMS_DDL.alter_compile('PR
10x in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
how are you invoking this?
what are the c# command object parameters you are using?
what are the c# command object parameters you are using?
I typically get that error when I forget and leave the semi-colon at the end of the command.
If this doesn't fix it, please post the code that you are using.
If this doesn't fix it, please post the code that you are using.
ASKER
the problem solved with:
ALTER PROCEDURE RANGE1 COMPILE
10x
ALTER PROCEDURE RANGE1 COMPILE
10x
ASKER