Using oracle OTD Couldn't create prepared statement for deleting tablerow
Hi,
I am using JCAPS 5.1.1.
In JCAPS 5.1.1 i tried to create an OTD using oracle database .
In wizard,I selected only prepared statement. After
selecting tried to create a prepared statement for deleting a
row from table.
delete from tablename where coulmnname=?
(e.g) delete from membership where memberid=?
But got following error
[SeeBeyond][Oracle JDBC Driver]The requested parameter metadata
is not available for the current statement.
But if we substitute any value instead of "?" it works
delete from tablename where columnname="ttt"
delete from membership where memberid=222
Following statements for insert,update works well other than delete
insert into tablename values(?,?,?)
update tablename set columnname=? where coulmnname=?
In earlier discussion thread for this kind of problem it has been mentioned as it might be a bug in 5.1. If that is the case, Please let me know is there any work around for this other than upgrading to higher version.
Steps followed
1) Created Project
2)Tried to create OTD using oracle database end up with the error
message
Note :
The similar error message we will get if we enter any incorrect tablename/column which is not present in database/table.
My colleague told it might be an installation problem.
Please let me know is it an installation problem or a problem in JCAPS 5.1.1
Message was edited by:
VenkateshSampoornam
