ORA-01460: conversion not implemented or not resolvable.

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
andersonbelino
Posts: 1
Joined: Tue 08 Dec 2020 02:42

ORA-01460: conversion not implemented or not resolvable.

Post by andersonbelino » Tue 08 Dec 2020 02:51

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: ORA-01460: conversion not implemented or not resolvable.

Post by MaximG » Sat 13 Feb 2021 12:43

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

Post Reply