I have a procdure as follows:
procedure test(aClob in clob) is
begin
insert into aTable(aField) values (aClob);
commit;
end;
When I call this procedure from outside with a string as a parameter to aClob, I get following error:
SQL>execute test('a test parameter');
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
How can I fix this problem.