I have written a procedure which is as follows:
CREATE procedure insemp (tid IN varchar2,tdocout IN blob)
INSERT INTO emp (id,docout) VALUES (tid,tdocout);
so second parameter(docout) to this procedure is of type blob, and docout which is in table emp is of type blob, so I am trying to insert tdocout into docout field of emp table.
but when I am trying execute this procedure from sql* plus as
I am getting the error
PLS-00306: wrong number or types of arguments in call to 'INSEMP'
ORA-06550: line 1, column 7:
and even from java program I am getting the same error.
when the data type is not blob I am able to execute the procedure properly.
So I want to know how to pass blob type to procedure, Is there is any other way or pl/sql does not support blob type?