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
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
.NET ProgrammingOracle Database
Last Comment
gudidi
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
i still have the same error
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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