I am using PostgreSQL 9.3 and ZEOS 7.1.3a stable. For example I have test function:
CREATE OR REPLACE FUNCTION vl_test(IN param1 integer, IN param2 varchar, IN param3 integer, IN param4 smallint, OUT param5 integer) ...
In delphi I am calling TZStoredProc with this code:
proc.ParamByName('param1').AsInteger := 1;
proc.ParamByName('oaram2').AsString := 'test string';
proc.ParamByName('param3').AsInteger := 1;
proc.ParamByName('param4').AsInteger := 1;
proc.ExecProc;
and getting EZSQLException with message:
"Function vl_test (integer, unknown, integer, integer) does not exist. Unable to identify function that satisfies the given argument types. You may need to add explicit typecast."
After searching internet I found article that says: PostgreSQL 9.3 has no auto typecast like older versions. So, to make stored procedure working it is necessary to use explicit typecast.
Is there any way to add explicit typecast to TZStoredProc params?
PostgreSQL procedure parameters typecast
The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Return to “ZeosLib 7.1 stable Forum”
Jump to
- Links
- ↳ Bugtracker
- ↳ Downloads
- ↳ Subversion
- ↳ GitHub
- ZEOS Library - General
- ↳ Announcements
- ↳ Downloads
- ↳ Documentations
- ↳ Tutorials
- ↳ ZDBC (ZEOS Database Connectivity)
- ↳ User Contributions
- ↳ Feature Requests
- ↳ User Patches
- ZEOS DBO v8.x
- ↳ ZeosLib 7.3/8.0 Forum
- ZEOS DBO v7.x
- ↳ ZeosLib 7.2 Forum
- ↳ ZeosLib 7.1 stable Forum
- ↳ ZeosLib 7.0 Stable Forum
- ↳ ZeosLib 7.0 Beta Forum
- SQL Servers and Databases
- ↳ ADO
- ↳ DB2
- ↳ Firebird
- ↳ Interbase
- ↳ MS SQL Server
- ↳ MySQL
- ↳ Oracle
- ↳ OleDB (Microsoft Windows)
- ↳ ODBC
- ↳ PostgreSQL
- ↳ SQLite
- ↳ Sybase ASE
- Compiler related
- ↳ CBuilder / C++
- ↳ Lazarus / Freepascal
- ZEOS DBO V 6.x
- ↳ 6.6 - stable
- ↳ 6.5.1 (alpha) - 6.6.x (beta)
- ↳ 6.1.5
- ↳ Other 6.x Versions
- ↳ Bug Reports
- ZEOS DBO V 5.x
- ↳ 5.x Versions
- Software projects using ZeosLib
- ↳ SQLite Administrator
- Other and Non-Technical
- ↳ Off Topic