Category Archives: PL/SQL


Here is a recent thread from OTN forums. The question raised is WTF? whether a hint in the examples section of DBMS_PARALLEL_EXECUTE documentation have to be used or not and why it is there. What do you think about it? Have a look in the documentation and mark your choice in a poll:

PS. In my view it’s a bug. I left a comment in the documentation about it, but didn’t receive any reply yet.

Cardinality of table collection expression

Table collection expression has been in Oracle for more than 10 years. It is handy for passing an array to Oracle. Quite often, though, there is was a well-known problem with a default cardinality associated with table collection expressions used in the SQL.

Continue reading

ORA-1410 on UPDATE

Interesting topic appeared on Oracle forum In short, an issue is a PL/SQL code, which produces “ORA-01410: invalid ROWID” exception when it shouldn’t. 

Continue reading

“New” operators of PL/SQL

New PL/SQL “operators” discovered by Elic @

Continue reading