Hi Oracle fans,
I am facing a typical problem. I am able to execute a single sql from a procedure in sql prompt with parameters hardcoded the query is executing fine, the same syntax i am unable to execute as a procedure / package, it is simply going and coming out in 1 sec and the debugging messages are displayed, but no dml statements are executing. can anybody solve this problem.