what is the maximum length of a unix shell variable which can be can passed to plsql variable:(
Are you referring to a command-line plsql statement? If so, it will be limited by the length of the command line, which you get from "getconf ARG_MAX". It will be further limited by plsql's command line parsing implementation.