Not allowing to delete record from .net Application
Dear All,
We are facing one Problem that..
In our System one table COUNTRIES is there on which we are Performing a Delete Operation of a record through the Application at that time it gives an exception like this
" Dynamic SQL generation for the DeleteCommand is not supported against a
Select Command that does not return any key column information."
and when we do same delete Operation in sqlplus it will successfully executed...
the Database Version is Oracle 10.1.0... and the source code is developed in VB.net..
(the table has only column country_name and itself it is primary key......)
In our System one table COUNTRIES is there on which we are Performing a Delete Operation of a record through the Application at that time it gives an exception like this
" Dynamic SQL generation for the DeleteCommand is not supported against a
Select Command that does not return any key column information."
and when we do same delete Operation in sqlplus it will successfully executed...
the Database Version is Oracle 10.1.0... and the source code is developed in VB.net..
(the table has only column country_name and itself it is primary key......)
0