set wrong parameter datatype

[sinys]

When I can set wrong parameter datatype like this:

Code: Select all

  OraSQL1.SQL.Text := 'begin' + #13#10 +
'   open :curs for' + #13#10 +
'     select * from scott.emp;' + #13#10 +
'end;';

  OraSQL1.ParamByName('curs').ParamType := ptInputOutput;
  OraSQL1.ParamByName('curs').DataType := ftString;
  OraSQL1.ParamByName('curs').Size := 4000;
  OraSQL1.Execute;

sometimes the application hangs on Execute command instead generate an error.
Do you have any ideas why it possible?

[AlexP]

Hello,

We couldn't reproduce the problem. When executing such a block, the correct Oracle PLS-00456 error occurs. Please specify your exact versions of Oracle client and server, IDE, and ODAC