I am trying to called a stored procedure in oracle from a unix script and pass it a variable. I am having a problem with the size of the variable. It is 16125 bytes. The max size on for SQL Plus command line length is 2500 bytes. Is there a way could go around SQL Plus and talk directly to my procedure??
I know no way leading around sql-plus, but you could write the content of your variable into a temporary file, which your procedure could read (using the UTL_FILE package).
I didn't find any way of piping the data into oracle stored procedures.