Devart Forums

I'm having trouble running storeprocedure on delphi 10.2 version unidac 7.2.7, oracle 19C.

Procedure Oracle.

PROCEDURE P_INSERE_PRG_INSTALL_SCRIPT(P_SPIN_SCRIPT IN PRG_INSTALL_SCRIPT_TESTE.SPIN_SCRIPT%TYPE)
IS
BEGIN
DELETE PRG_INSTALL_SCRIPT_TESTE;

INSERT INTO PRG_INSTALL_SCRIPT_TESTE
(SPIN_SCRIPT, DATA)
VALUES
(P_SPIN_SCRIPT, SYSDATE);
END;

Routine implemented in delphi

procedure TForm1.Button3Click(Sender: TObject);
var
M : TStringStream;
begin
M := TStringStream.Create;
M.LoadFromFile(edit4.Text);
try
if not PreparaStoredProc ('GONDOLA.AM_TESTE.P_INSERE_PRG_INSTALL_SCRIPT') then
exit;

UniStoredProc.ParamByName('p_SPIN_SCRIPT').DataType := ftString;
UniStoredProc.ParamByName('p_SPIN_SCRIPT').AsWideString := m.DataString;
UniStoredProc.ExecProc;

except
on E: Exception do
begin
Showmessage(E.Message);
end;
end;
end;

when executing the routine, the error below is returned:
ORA-01460: conversion not implemented or not resolvable.

I have tested it in several ways but I can't come up with a solution. Even doing the insertion routine as presented in the forum on another topic I get the same error.

Thank you for your patience. Unfortunately, we could not reproduce the issue according to your description. Please compose the simplest full sample, in which the issue occurs, as well as a script to create all Oracle objects used in this sample. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html