Dynamic SQL in Oracle Stored Procedure thro' ASP
Posted on 1999-11-22
suppose that i have a stored procedure that takes in an SQL command as input parameter and executes that statement.
We need to call that procedure through ASP.
The problem arises when we pass a SQL command, with a quoted string such as 'select * from temp where c1 = 'gh ' '
" ADODB.Command error '800a0d5d'
The application is using a value of the wrong type for the current operation. "
How could this be solved...
Thanks and Any help in this regards is appreciated.