you have to code for it in your app (like sqlplus does)

or get the dba to do it...